Earlier, I asked about how to filter characters and select the ones that I want to include in a unique identifier for my customer table.  The code Kevin gave me on that conversation has been working well.  The only problem I had was that I couldn't get the code to save into the company table.  I only had the codes available through a query and combo box.  I want to end with being able to search for the company with it's code, however, so I finally decided to add a field for the code in the table and use a Dlookup from the query to fill in the field with an after update event.  Doing this, however made the for refuse to update and let me move to another record, even though it saved the entire record to the table. I'm not sure why, except it keeps saying I have an undeclared variable.  The part that confuses me is that it is claiming a field name as the undeclared variable... I will upload a picture of the error below. and it won't let the record refresh now. It didn't do this before I decided to use a dlookup to update the companycode field.  I'm at a loss as to how to make it work right again. Can someone please help me?

Thank you so much to Richard, Kevin, and everyone else that is sooooo helpful on here!