I have been developing a power plant database and want to give the user two entry routes. One route lets the user select a power plant from a list on a form and then loads a tab control with all the information about that plant in various categories. Selecting different tabs presents different categories of information. For the most part, this scheme works well. I setup this form following the general scheme:
create a query that selects all plants;
create a form bound to this query;
Add a tab control;
Add a subform to each tab page ensuring correct parent/child links;
Add a combo box to the main form.
So far, so good (many thanks and much gratitude to Pat Hartman). There are five information categories so the tab control has five tabs. One tab, 'Plant Descriptions' does not work; the tab page is blank. Also, when I open the main form, the following error message appears:
You tried to lock table '~sq_cThird Form~sq_cPlant Descriptions'
while opening it, but the table can't be locked because it is
currently in use. Wait a moment, and then try the operation again.
Each tab page was setup using an existing form and all those forms, including 'Plant Descriptions,' work well. The Plant Descriptions form is based on query of the Plant Descriptions table. This table does not have a construct in it that has not been used elsewhere. Evidently, there is something different about either the Plant Descriptions table, query, or form but it is not immediately obvious to the casual observer (me). All three of these entities work as expected but the Plant Descriptions form does not work when used as a subform. Any suggestions?
Breathless in DC
Old chemists never die, they just fail to react
create a query that selects all plants;
create a form bound to this query;
Add a tab control;
Add a subform to each tab page ensuring correct parent/child links;
Add a combo box to the main form.
So far, so good (many thanks and much gratitude to Pat Hartman). There are five information categories so the tab control has five tabs. One tab, 'Plant Descriptions' does not work; the tab page is blank. Also, when I open the main form, the following error message appears:
You tried to lock table '~sq_cThird Form~sq_cPlant Descriptions'
while opening it, but the table can't be locked because it is
currently in use. Wait a moment, and then try the operation again.
Each tab page was setup using an existing form and all those forms, including 'Plant Descriptions,' work well. The Plant Descriptions form is based on query of the Plant Descriptions table. This table does not have a construct in it that has not been used elsewhere. Evidently, there is something different about either the Plant Descriptions table, query, or form but it is not immediately obvious to the casual observer (me). All three of these entities work as expected but the Plant Descriptions form does not work when used as a subform. Any suggestions?
Breathless in DC
Old chemists never die, they just fail to react
