Populating a form
I have problems using the Dlookup function in Access 2003 to populate the fields on the form when the user searchs for a record and finds it.
This is my basic form layout:
A text box called txtStoreId used for the search criteria and a button btnFindStore next to it. When the user selects this form, initially txtStoreId is empy, but on the fields I try to populate a # Name? appears.
For example in my txtStoreName field, I used this on the DataSource property of the control:
=Dlookup("[StoreName]", "tlbStore", "StoreId = '" &"[txtStoreId]" & "'")
I deleted the code for the button btnFindStore, perhaps I need to add some code here.
Any help will be greatly appreciated it!
P.S. I would like to attach my db but I didn't see the option.