Form behavior changes after switching to design view and back

[sterlecki]

I have a form with a tab control and multiple page controls. Each page has at least one subform on it. Subform data originates from a query based on it's own table.

All tables are in a one to many relationsip with the table that uses page one and it's subform.

Data is queried using two unbound comboboxes on MainForm each subform on each page uses one of these two controls as criteria in their queries.

Problem: While developing (changing back and forth from form to design view) this appeared to have been working fine. While testing the finished product I noticed that the first time I open the form and make selections only the first subform was being populated. This form is on the first page of the tab.

When I change to design view on the Main Form and back again, make my selections, then all the subforms on all tabs requery and display properly.

Your thoughts.

 

[sterlecki]

Found out the Problem??

One of the last things that I did in finalizing the Application was to create a switch board.

Unfortunately after 4 hours of questioning my code I discovered that through the switchboard the form was opening in Add mode instead of Edit mode.

I discovered that by opeing the form from the DB pane instead of the switchboard that the form worked fine which triggered an investigation into my switch board choices and discovering an inappropriate selection.

The devil is in the details but "Why is it so DIFFICULT to find SIMPLE mistakes?"

Hope this might save someone else a few hours!