Call data collection form from Function and wait till form close t

[Guest]

I am importing data from an XLS. After reading in the records into a
recordset, I have a function that steps through each row. If a potential
duplicate is found, the Function calls a form that displays the current entry
and all duplicates as encountered and allows the user to select the new
record or one of the existing ones to use.

Issue: I am successfully calling the dupliaction form (
DoCmd.OpenForm "frmPickFromDuplicates", acNormal, , , acReadOnly, , strParPKs
) and it does everything it is supposed to BUT the function code continues
to process without waiting for the data entry form to have the user select
and then close. thererfore it blows since it does not have the feedback
required from the form.

I have tried Modal, Dialog and other combinations but to no avail...

Desired: While processing thru Function, if a potential duplicate is
encountered, call the form that offers the user the display of the duplicates
and the option to select which one to use. When the user makes the selection,
the form goes away and the processing in the Function begins the line after
the form call.

 

[Albert D.Kallal]

I expalin how you do this here:

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