I created an application that has been in successful use for several years. Until recently, records were keyed directly into the application and a particular field (the Vehicle Identification Number, or VIN) was checked for errors through an AfterUpdate event (via code). This error check is very involved and mandated by the federal code. We have since changed the overall dealership software which affords us the opportunity to import data directly from it to this application. I am NOT a trained programmer, but have had much success and experience with Access. What I’ve never had to learn is how to loop thru records and perform operations. Unfortunately my attempts this far have been less than fruitful.
What I want to accomplish is to open a report that identifies all records with invalid VIN’s. It would show the RunNo (a distinct number), the VIN, and one of 4 different error descriptions (text). I tried to do this with a While Not rst.EOF loop that performed a RunSQL to append the records to a temporary table. It didn’t work 
Probably because I didn’t do it correctly, I’m sure.
I’ve attached the code that does the error check as records are added to the “AvailAutos” table, which is also the RecordSource for the form the code runs from.
Any help will be greatly appreciated.
Kathi in Birmingham, AL
