Does anyone have suggestions for creating a find function on a form that doesn't involve DAO. I cannot get the Jet database engine on my computer and I have been designing everything with VBA and docmd stuff. My boss wants a form that searches for a record using a customer number field. The problem is he wants the field that you enter the number to search for to be the same that displays the customer number. I bound this form to a customer table. I then used the docmd.findrecord using the customer number field. This was the only was I know how accomplish this without DAO. Since these are live records, as you know when you enter something into a field you are updating it and a search is impossible. I prefer to have a search field and a field that shows the record field anyway but my boss wants what he wants. If someone gets what I am trying to say and has some suggestions I would appreciate it. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search options
- Thread starter ErnNJ
- Start date
- Status
Similar threads
