LOOPING A FORM TO RELEASE & OPEN REPEATEDLY

[greg22]

Hi,
I a have developed a Form(set) named Invoice and have included it in a MENU. The invoice(form) works great
within the MENU but the USER complains that they don't
want to have to go back to the MENU everytime they finish
an invoice.

How can I RELEASE the formset which has Form1 & Form2 in
form2 and after the invoice is printed. In Form2 I have
a Command button which closes all databases and Set Printer
To a REPORT then releases the Formset back to the Main MENU.
Is there a way I can REFRESH both Forms 1 & 2 within Form2.command1 Button of the formset. The lines of code
I currently have in Command1 button are as follows:

CLOSE DATABASES
SET PRINTER TO ?? report to print up the current invoice
THISFORMSET.RELEASE ?? then returns to MENU

I've tried to refresh both Forms 1 & 2 then set Form1 to
Visable but I get an error message:"UNKNOWN MEMBER FORM1"
within Form2.Command1 Button. How can I continously loop
Form(Invoice) because the USER has between 50-100 invoices to do daily??

Thanks Greg

 

[Nifrabar]

Greg,
I've been advised not to use formsets.
Having said that:
Once you like to release a formset the syntax is:
thisformset.Release
The syntax for refreshing form1 should be thisformset.form1.refresh
But why do you close the database manual and than again try to refresh the form; this needs to have open table or view; so also an open database.

 

[TamarGranor]

As Bart said, don't use formsets.

In addition, why do you want to close and reopen the form after each invoice? Why not just clear the data and put the user back in the first field?

Tamar