Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening a Form In a For Next Loop

Status
Not open for further replies.

SaturnSeven

Programmer
Aug 4, 2005
40
GB
I am trying to do the following
For i = 1 to 3
Open form "frm"
field "fld".value = Array(i)
Wait for user to make other selection on form "frm"
When user hits OK, write data to table. Close Form "frm"
Next i

It's the wait for the users input thats stumping me, I'm OK on the rest.
Any help or pointers would be greatly appreciated

 
You can open the form with the WindowMode set to acDialog. This will make it Popup and Modal.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top