Link to home
Start Free TrialLog in
Avatar of mrroonie
mrroonieFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of mrroonie
Flag of United Kingdom of Great Britain and Northern Ireland image


BTW - the asset_ID field is a text field, not numeric
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
perfect - thanks!
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:

sorry - i accepted the wrong comment - please accept LSMConsulting as the answer and award all points