A
Antonio
I have a form that uses a tab control to display 2 sub
forms for each of the 4 "Tabs" located on the tab
control. Each of the sub forms on the individual 4 tabs
has a different function. I added some very basic code to
the sub forms Before Insert events to add specific data
elements to data fields located on the subform according
to the local date and time. Most of the code consists of
IIf statements. The problem I am having is that the form
takes 10 to 14 seconds to open. Is there a way decrease
the time it takes for a form to open? I am wondering if
it was the way I added the code to the individual sub
forms that has bogged this particualar form and tab
control to bogg down so. (Incidentally, this is version 2
of a previous form where I left it to the user to
properly fill in several data values depending on the
time of day. The old form opend in a second. They users
had all kinds of problems with the old form and that is
why I added the code to automatically fill in the data
fields for them)
forms for each of the 4 "Tabs" located on the tab
control. Each of the sub forms on the individual 4 tabs
has a different function. I added some very basic code to
the sub forms Before Insert events to add specific data
elements to data fields located on the subform according
to the local date and time. Most of the code consists of
IIf statements. The problem I am having is that the form
takes 10 to 14 seconds to open. Is there a way decrease
the time it takes for a form to open? I am wondering if
it was the way I added the code to the individual sub
forms that has bogged this particualar form and tab
control to bogg down so. (Incidentally, this is version 2
of a previous form where I left it to the user to
properly fill in several data values depending on the
time of day. The old form opend in a second. They users
had all kinds of problems with the old form and that is
why I added the code to automatically fill in the data
fields for them)