navigating on forms...

  • Thread starter Thread starter Ayala
  • Start date Start date
A

Ayala

Hi, I have 6 forms which capture info for a service
report. I have one form for 1 step of the service. I try
to put as few controls as possible.. but anyways forms are
opening to slow. What I have now is:
A main form where the user selects an OrderNo. from a
combobox, with this order no used as a unique identifier I
open an close the rest of the forms.
Every form has a next and previous button which moves to
the next or previous form. When clicking on any button I
close the present form and open the previous or next form
using DoCmd.OpenForm "frmName", acNormal, , strSQL; where
in strSQL I'm passing the OrderID. But this is too slow..
So I tried not opening and closing every form but just
using putting visible = True/False depending on the case,
and then Requering so I'm still viewing the info for the
specified OrderID. But this causes a Write conflict every
time any record is changed on any form.. the data is lost
or corrupted.

which is then the proper way to move around this forms??
thx in advance.
 
Ayala said:
Hi, I have 6 forms which capture info for a service
report. I have one form for 1 step of the service. I try
to put as few controls as possible.. but anyways forms are
opening to slow. What I have now is:
A main form where the user selects an OrderNo. from a
combobox, with this order no used as a unique identifier I
open an close the rest of the forms.
Every form has a next and previous button which moves to
the next or previous form. When clicking on any button I
close the present form and open the previous or next form
using DoCmd.OpenForm "frmName", acNormal, , strSQL; where
in strSQL I'm passing the OrderID. But this is too slow..
So I tried not opening and closing every form but just
using putting visible = True/False depending on the case,
and then Requering so I'm still viewing the info for the
specified OrderID. But this causes a Write conflict every
time any record is changed on any form.. the data is lost
or corrupted.

which is then the proper way to move around this forms??
thx in advance.
Click to expand...

If you have multiple forms attempting to write to the same record then that
is part of your problem. Access considers two forms editing the same
record to be a conflict even if those two forms are being used by the same
person on a single PC.

If you are using multiple forms just to organize the controls why not just
use a single form with a TabControl? Then you can spread your controls over
multiple TabPages, but it will still only be one form to open and edit the
record with.
 
Back
Top