Navigating Subform Records

S

Steven V. Olson

Sandra,

I changed the code to the following:

With Me.[RX Input Form].Form.RecordsetClone
'Make sure there is at least one record.
'RX Input Form is the name of the subform under
'the Other tab of the of the Property Sheet of
'the subform when the main form is opened in
'design view.
If Not .EOF And .BOF Then
'Moves to last record on the subform.
.MoveLast
Me.[RX Input Form].Form.Bookmark = .Bookmark
End If
End With

However, when I run the click event I get the following
error:

"Microsoft Access can't find the field 'l' referred to in
your expression."

?

Steve Olson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top