My form has a button to run a query, but if I enter my info on the form and press the query button, the information isn't included on the query. To get it to work I have to go to another record, then back to the one I was on, and then I can get the correct query. Anyway to have it update automatically?
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need Form to update before query runs
- Thread starter mattborn
- Start date
psemianonymous
Programmer
In the code you run your query, immediately before do a
That should save the current record (or error trying).
Code:
RunCommand acCmdSaveRecordThat should save the current record (or error trying).
- Status
Similar threads
