Form after Search filtered

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

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:

Users who are viewing this thread

Back
Top Bottom