Wait for adding a record to a form

[SAC]

ms access 2003

I'm want to add code to a not in list event for a control.

I want to open a form, add a record and then requery the control....the
problem is I don't know how to stop the code that runs after I open the form
to add a record.

Is it a doevents command? I tried that but was unsuccessful.

Thanks for your help.

 

[Tom van Stiphout]

You need to open that form modally, so the next line only executes
after you close the form:
DoCmd.OpenForm "myForm",,,,,acDialog

-Tom.
Microsoft Access MVP

 

[cabos.antoine]

ms access 2003

I'm want to add code to a not in list event for a control.

I want to open a form, add a record and then requery the control....the
problem is I don't know how to stop the code that runs after I open the
form to add a record.

Is it a doevents command? I tried that but was unsuccessful.

Thanks for your help.

 

[SAC]

Thanks!!!!

You need to open that form modally, so the next line only executes
after you close the form:
DoCmd.OpenForm "myForm",,,,,acDialog

-Tom.
Microsoft Access MVP