Go to selected record on a list stops working after...

[Deisun]

I need help getting a list to go to selected record.



I have it working with this code, BUT...

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.

[rpeare]

can you post a sample database with garbage data? it's likely that something you're doing with your advanced search is screwing with the functionality of your clients form and I'd rather not have to recreate it to test for the error.

[Deisun]

Sure. Here is a sample of my DB:

[rpeare]

Ok I can't seem to replicate your error, walk me through exactly what you are doing and exactly what you are clicking to make the form 'not work'. And if it's just flat out not doing what you want it to rather than a specific error tell me what it is supposed to do.

[rpeare]

oh wait, I think I see, you get a pop up that say

not found: filtered?

You likely need to not only reset your filter

me.filter = ""
me.filteron = false

this is why I don't use filters

I just added a button on the main form with those two lines of code, then when I was able to get that error to pop up I clicked that button and I was able to navigate the list box again.

[Deisun]

Hrm, making a button and throwing those lines in there didn't work for me.

[rpeare]

it depends on your process. Put it anywhere where there's a termination of viewing a filtered item from your advanced search form. likely you could simply use the ON CLICK event of your list box to clear the filter and turn it off.

[Deisun]

Thank you very much rpeare - I've got it working perfectly now thanks to your help. +rep to you