M
M Skabialka
I am creating a new form which has information from 3 tables on it. The
info from two of the tables is for reference only and is included on a
report which is generated, the other information is created then saved for
later reference.
Right now I have the user choose Employee # from a combo and employee data
fills the form based on grabbing info from 10 columns in the combo. The
same is done with the other table. All I save is the Employee # and the
other key field from the other table into the 3rd table, along with new
information for the report.
This seems to work very slowly, and when the user scrolls through the
records with the navigation buttons, it takes forever to fill out all of the
fields from tblEmployee and the other table, because it is doing a DLookup
on about 25 fields.
When I tried to use sub-forms, if the employee # wasn't selected yet the
entire subform became invisible.
What's the most efficient way to design this form?
Thanks,
Mich
info from two of the tables is for reference only and is included on a
report which is generated, the other information is created then saved for
later reference.
Right now I have the user choose Employee # from a combo and employee data
fills the form based on grabbing info from 10 columns in the combo. The
same is done with the other table. All I save is the Employee # and the
other key field from the other table into the 3rd table, along with new
information for the report.
This seems to work very slowly, and when the user scrolls through the
records with the navigation buttons, it takes forever to fill out all of the
fields from tblEmployee and the other table, because it is doing a DLookup
on about 25 fields.
When I tried to use sub-forms, if the employee # wasn't selected yet the
entire subform became invisible.
What's the most efficient way to design this form?
Thanks,
Mich