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!

Register Log in
  • Congratulations strongm 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

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

 
Sort by date Sort by votes
You can open the form with the WindowMode set to acDialog. This will make it Popup and Modal.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
390
SoftwareRT
SoftwareRT
AJAY0618
  • Locked
  • Question
How to pass a variable in VBA code by opening a form and storing the variable
Replies
3
Views
147
AJAY0618
AJAY0618
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
270
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
650
dhookom
dhookom
Moss100
  • Locked
  • Question
Make database appear as just a form
Replies
1
Views
106
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top