Open a form using a comand button on another form

[Michalis J.]

By using a command button on a certain form I am oppenig an other form at a
cetain record by using some criteria. I am using the command button wizard
to do that. When the form oppens however, I want to be able to move to other
records of the form record source. Is there an easy way to do that?
Thanks in advance
Michalis

 

[Allen Browne]

Instead of passing the criteria in the WhereCondition, pass it in OpenArgs
instead.

Then use the form's Load event to FindFirst in the RecordsetClone, and set
the Bookmark.

 

[Michalis J.]

Thanks a lot Allen. That really helped

Instead of passing the criteria in the WhereCondition, pass it in OpenArgs
instead.

Then use the form's Load event to FindFirst in the RecordsetClone, and set
the Bookmark.