I need help getting a list to go to selected record.
I have it working with this code, BUT...
Code:
Sub SearchResults_AfterUpdate()
Dim rs As DAO.Recordset
If Not IsNull(Me.SearchResults) Then
'Save before move.
If Me.Dirty Then
Me.Dirty = False
End If
'Search in the clone set.
Set rs = Me.RecordsetClone
rs.FindFirst "[ID] = " & Me.SearchResults
If rs.NoMatch Then
MsgBox "Not found: filtered?"
Else
'Display the found record in the form.
Me.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End If
End Sub
Works great but I have a second form (called Advanced Search) that is a more thorough search and when users click a search result there it comes back to my main form (with the quick search list described above). Once that happens though, the list in my form seems to not go to records when clicked.
The Advanced Search form just has a box that overlays on top of every search result with a Open form and Selected result macro that reads:
Clients, Form, , ="[ID]=" & [ID], , Normal
So just to recap:
2 different Forms: 1) Clients Form. 2) Advanced Search
1) Clients Form has a list of all clients that can be selected and it will go to the record (displayed on the same form)
Selecting from the list works perfectly BEFORE using the link from the Advanced search.
2) Advanced search has a button for each result with that macro described above.
The list on the Clients form stops working when I come from this Advanced Search Form via that button.
Any help is greatly appreciated guys, been stumped on this one for like 4 hours now.
I thought maybe setting me.filter = "" for the Clients Form On load would fix it but no luck.