troubleshooting Question

Access 2010 Open a second form to the record selected on the first form, but still include all records

Avatar of mrroonie
mrroonieFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
5 Comments1 Solution494 ViewsLast Modified:
Hello all

i am creating an asset register using Access 2010. i have a user form that lists assets currently designated to that user in a subform, and i have another form that gives more details on the asset (serial etc).

i would like to be able to double click the asset listed in the users form to then open the asset form at the correct record. i have added code that works to this effect, but not exactly how i'd like it - the code i have is:

Private Sub Type_DblClick(Cancel As Integer)

DoCmd.OpenForm "frm_Asset", , , "Asset_ID = '" & Me.Asset_ID & "'"
End Sub

this opens the frm_Asset at the correct record but it's filtered, so the user needs to turn the filter off if they need to search through the main database. once the user turns the filter off the form then goes back to record 1.

is there anyway i can do this so it just jumps straight to the record, rather than filtering it out?

thanks in advace for suggestions
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros