open form during recordset update

[david.lara]

Hi
i want to be able to open a pop-up form during a recordset update that
relates to each record being updated. At the moment the form will open up for
the first record, but the rest of the records in the record set are updated.
Current code goes something like this:
with rst
do while not rst.eof
.edit
!blahblah = xyz
...
.update
docmd.openform "frmPopUp",,,"RecordID = " rst!recordID
.movenext
loop
end with

i want to be able to perform an action on the frmPopUp, in this case
print/preview/email a report in relation to rst!recordid, for each of the
records in the recordset.
Thanks

David

 

[Dorian]

Try setting WindowMode property of OpenForm statement to 'Dialog'.
Look in Access Help for parameter details.
Hope this helps.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".