Find Record

[dwaterman]

I am working in Access 2010. My main control on my form is a Serial Number field. My form opens to a new record. I would like to be able to enter the Serial Number in this field and have Access go to this record if it exists. If it does not exist, to continue to the next field, since I would want to create a new record. I tried using DoCmd to locate the record in the before update event, but I get an error message about not being able to add the data. If I use the After Update event, I assume I would be creating a new duplicate record before moving to the existing one. Any suggestions?

[orange]

Watch this free video from youtube. It says 2013 but it will work fine in 2010. It may give you some ideas, and will show you some coding concepts.
https://www.youtube.com/watch?v=N0X8Hg-Sm6A

[dwaterman]

Thank you for your response. I am trying to mimic other software we use where the search is not from a separate field, but happens in the form. This video was very good at explaining filters and how to do things without using the wizard. It was helpful.