Me.form.bookmark = me.form.recordset.bookmark seems to work. Thanks. There's a bit of a delay before the screen pops up with the data, but I suppose I can live with that. I'm only dealing with 450 records.
Yes, I tried it but was not sure how to set the bookmark in the Forms recordset, at least it is not highlighting the correct record, it defaults to the 1st record.
Me.Form.Recordset.Filter = "[EmpKey] = '" & strSave & "'"
What follows the Filter command? Thanks.
What I am trying to do is set the current record pointer in the continuous form to the saved key, which is why I use the FIND command. It does not seem to work if the key is in descending order.
I have a Form with a subform. The subform is a continuous form. Upon clicking the subform area, I highlight the selected row and display the details. When a Sort option is selected, I want to keep the current line highlighted. To accomplish this I use the following code: (Access 2002 'adp' SQL...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.