Launching a Second Form

[slrphd]

I have a form with several command buttons on it. Clicking on the command button runs a macro that opens a second form which takes its data from a query. I put a condition in the macro that one of the fields have a specific value corresponding to a specific plant. When I click on the command button for a certain plant, the second form opens with the information for that plant. So far, so good. Since the amount of information I wish to recall is large, I put a tab control on the second form which allows me to recall the information by categories. When I had only two categories on the tab control, everything worked fine. When I added a another table to the query to bring in another category of information, things go wrong. Some of the command buttons work, most do not. I click on the command button and get a popup asking for the field value as a query parameter. When I run the query independently, it works as expected. Any Ideas? Thanks.

 

[aleb]

Can you post a db?

 

[slrphd]

Alexei,
Thanks for your interest. The db now contains some senstive information and I cannot really post it. The problem turned out to be a broken reference to another table. I had renamed the table and I should know better than to do that at this stage of development. Thanks, again.