I highlight / filter to see other movies by same composer.
When I unfilter, the view is reset to record one.
I wanted to create a piece of code to 1) select the primary key of the active record (while filtered) 2) set the filter property to false 3) go to the record active when I pressed the button.
I would assign a button to a macro which would runcode the module.
I can't remember the way to reference the immediate record's primary key. I tried:
Expand|Select|Wrap|Line Numbers
- Function CurrentRec()
- Dim KEY As Variant
- With qryMovieCinemaComposer
- KEY = qryMovieCinemaComposer.KEY
- .FilterOn = False
- .Recordset.FindFirst "[KEY]=" & KEY
- End With
- End Function
John