Sub Sub Form Query Will not wait for main form to be populated.

[TravelingHT]

Dear All:

I have a query in a sub sub form that, on the result of the value input into
one of the fields in the main form populates a dropdown list with the names
of pets owned by the customer who is the focus of the main form.

How do I make the impatient sub sub form be patient.
As soon as I open the main form I get a popup box asking for a value so as
to populate the dropdown list in the sub sub form.

How do I get the sub sub form drop down list to wait untill I have had a
chance to fill out the customer name in the main form?

 

[boblarson]

Subforms are loaded BEFORE the main form so you will need to provide a
default value to use to avoid this.
--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________