Windows XP 
Access 2010 32bit
Hi, I'm trying to create a simple form to search a database in access. I have a couple of questions:
I am using a simple form with 3 fields (using textboxes). I want to be able to type in to any one of these fields and search that field for the typed in value and populate the other fields (textboxes) with the appropriate data. The problem I'm having is that when I hit the find button that I added to the form, sometimes in the database, the values get written over with whatever was in one of the textboxes on the form. How do I either prevent this from happening or lock the database and make it read only? I'm sure it's a pretty easy problem but I'm stumped.
The second thing I want to do is have one of the fields auto search once a certain number of characters are typed in, using the docmd.findrecord in the change event in VB code. I seem to have the same problem with fields being overwritten in the database the same as above, but I also can't get the docmd.findrecord to work properly, even though I think I've entered in all the arguments correctly. It should work just like the find button correct? Can anyone give me an example of how to use this command?
Reason being is I want to use a barcode scanner in the one field and after scanning I want the form to automatically search for the barcode value and populate the other fields based on that barcode value.
Reply With Quote
