Form Does not show for data entry

[djpearce]

I designed an unbound form to accept a date input. The form is opened from VBA using docmd.openform. I want it to open, allow the user to key in a date, and click ok.

The form opens, but execution continues to the next lines of code. It does not stop to allow the user to enter the date.

I have compared the properties with another form that I created that behaves ok, and can not find where I and going wrong.

Please help.

 

[pbaldy]

Try opening the form in Dialog mode, which should pause the code until the form closes:

DoCmd.OpenForm "FormName", , , , , acDialog