salamander
Registered User.
- Local time
- Today, 08:26
- Joined
- Mar 3, 2008
- Messages
- 18
Remove Filter on Form Search Results
Hi there,
On the main form (which displays all the records), there is a search form. On this form, one searches then clicks on the desired record. This closes the search form and reopens the main form.
The problem is, the main form displays the search result but one cannot click Next Record, previous etc. How can I make it so it just goes to the record and keeps navigation fine?
The code I am using for moving from search to Main is
I presume I need to put some sort of requery there?
Thank you good sirs.
Hi there,
On the main form (which displays all the records), there is a search form. On this form, one searches then clicks on the desired record. This closes the search form and reopens the main form.
The problem is, the main form displays the search result but one cannot click Next Record, previous etc. How can I make it so it just goes to the record and keeps navigation fine?
The code I am using for moving from search to Main is
stDocName = "frmMainBrowse"
stLinkCriteria = "[ID]=" & Me![lstSearchResults]
DoCmd.Close
DoCmd.OpenForm stDocName, , , stLinkCriteria
I presume I need to put some sort of requery there?
Thank you good sirs.
Last edited: