Hold the program like a msgbox

[janz]

Hi,
I created a function that compares 2 tables. If the data of 1 is not found in 2
(wrong spelling of a name) The functions asks for a check in Db 1
opens a form and allows the user to check the spelling in a smart way.
So far all is good.
However I first query for the mistakes and then one by one want to check the mistakes on the form. However when I open the form from the procedure the procedure goes to the next name.

Is there a way that I can stop that? Meaning my form should work like a msgbox. It should hold the program until the user gives a proper name back.

I guess I'm handling this the wrong way so any hints on how to handle such a situation will be very helpfull.

 

[RuralGuy]

Use the acDialog argument to make the form modal and halt execution in the 1st form.

 

[janz]

Thanks. RuralGuy that saved me a lot of headaches. Such a simple solution!

 

[RuralGuy]

Glad we could help.