Opening Single Records from Datasheet View

[pdowg881]

I have a form in datasheet view that has a user directory with a list of each person. On each row you can click to open another form that contains the users details using the below VBA:



DoCmd.OpenForm "User Details", , , "[ID] = " & Me.ID

But once you open to that specific record, no other records are available to navigate to.
I want to be able to stay on that detail form that was opened and go to another record.

How do I continue to pull up that specific user in my detail form, but also load the others so I can navigate to them from the detail form without having to go back out to the datasheet form?

Thanks.

[June7]

Code could open the form with full, unfiltered dataset, then 'move' to the desired record - which is a bit trickier.

One approach is to pass the ID to detail form in OpenArgs argument then code in the detail form would 'go to' the record.

DoCmd.OpenForm "User Details", , , , , , Me.ID


Code in detail form Open event using RecordsetClone and Bookmarks:

If Not IsNull(Me.OpenArgs) Then
Me.RecordsetClone.FindFirst "ID = " & Me.OpenArgs
Me.Bookmark = Me.RecordsetClone.Bookmark
End If

[JLCan]

Hi pdowg881!

Your procedure is OK. You end up with 1 record (the one selected) and the add record line. Now check the navigation bar: your dataset is marked as FILTERED.
Click this button then the whole set will be displayed...

Good luck, JLCantara.

[June7]

Interesting, guess I've never tested that. I often disable the navigation bar on forms so this is not available to users.

[JLCan]

Hi June7!

Disabling the navigation bar is no problem: I do it very often. Then move the Filter package to the QAT ribbon or your own ribbon!

Good work, JLCantara.

[June7]

I do have custom ribbon, just never found need to have the Filter toggle there. I have command button and code that clears filters.

Always more than one way ...

[pdowg881]

Maybe a simple way would be to have the filter dropped when the "Enter ID" or "Select User" controls get focus ? Would this work if I put that code in the first line of my after update code for those?

[June7]

Try the AfterUpdate event, what happens?