I have created a form which runs a query to search my database for lastname. Once the results of my query are displayed how can I go back to the form to select another last name without closing the query result?
I have created a form which runs a query to search my database for lastname. Once the results of my query are displayed how can I go back to the form to select another last name without closing the query result?
What do you mean 'runs a query' - opens a query object? Use the query as RecordSource for form. Requery the form.
If you want to retain the first results even while running a second search, that will require saving records or setting the RowSource of a listbox. How many simultaneous searches will you want to do?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
You'll need to temporarily assign/store the Records somewhere; in a Temporary Table used as the RecordSource for a Form, in a Listbox/Combobox or something like this. Exactly what would be appropriate depends on what your end goal is; a plain language explanation of that might help us help you.
A more logical approach might be to retrieve the Records via a Combobox and then do the assignment, but as I said, it all depends on your goal.
Linq ;0)>