Passing a Form's Recordset to a Dialog Form

[Guest]

Is there any way to pass the recordset of a form to a dialog form. The
dialog form is intended to receive and validates the data and then assign the
validated data to the active record of the form's recordset? Passing the
current record only would also work, because I just want to populate the
record using the dialog form. Any ideas will be appreciated.

 

[Albert D. Kallal]

Sure, just base the dialog form on the same table as the current form.


then go:

me.refresh
docmd.OpenForm "the 2nd form",,, "id = " & me!id ,,acDialog

The 2nd form will open to the same record...and the user can then update the
data.....

If you actually just need to prompt for a few values, then you can use a
un-bound form.

I explain how you can get a form to return values back here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html