Opening multiple forms and closing each one before opening the nex

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all
I posted a similar request earlier but the browser crashed so I don't think
it got posted.

I have an application where I wish to open a form, enter some information,
close the form using a button open the next form, enter some information,
close the form using a button etc for a defined number of forms. I need this
all to run in a loop as I will be reusing some of the information on each
form. I though of something like this:
Dim x as interger
For i=1 to x
DoCmd.openform "formname"
User enters data
CloseForm
Next

Thanks for any assistance
 
Hi Murray,

If it's a sequential set of information you are after, have you considered a
single form with a Tab Control on it, with a subform on each tab?

Otherwise, you could simply have the following in the on click event:

docmd.openform "NEXTFORMNAME", acviewnormal
docmd.close acform, me.name

Hope this helps.

Damian.
 
Back
Top