Iterating the entries of a sub-form

[Helmut Holzer]

How can I check with VBA-code, which entry of an Access
sub-form is currently selected

How can I iterate the entries of an Access sub-form with
VBA-code. thanks

 

[Gary Miller]

Helmut,

This is commonly done by referring to the 'RecordsetClone'
of the form. How you do it depends on what you are doing and
from where.

Me!YourSubFormControlName.Form.RecordsetClone.Bookmark
should give you access to the record that the subform is on
from the main form.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________