mrroonie
asked on
Access 2010 Open a second form to the record selected on the first form, but still include all records
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect - thanks!
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for mrroonie's comment http:/Q_27250491.html#36349272
for the following reason:
excellent
Accepted answer: 0 points for mrroonie's comment http:/Q_27250491.html#36349272
for the following reason:
excellent
ASKER
sorry - i accepted the wrong comment - please accept LSMConsulting as the answer and award all points
ASKER