Form with Tabs and multiple external queries

[chris.williams]

Hello all - I have a single form with tabs. Each tab has a search field for a record for an external data source.



The problem that I am having is that on loading of the form, all the queries are run (in the case of initial loading of the form, all records are returned from the external sources).

What I would like to to is to have the subforms run their queries when search criteria is submitted via an event instead of on form load. The query on event works fine, but I want to stop the query on subform load. Right now, the external sources are small, but they will grow and there are remote users so the connection speeds vary.

This will be a significant performance issue when the data sets grow.

Thanks...

[NTC]

you need to make these unbound forms (subforms) with no record source property.

hope this helps.

[chris.williams]

Well - that stopped the load issue, but now the forms are broken and don't return data on the search. Got #name errors. I guess I have to specify the data source and field names for each control object.

[chris.williams]

Hmmm... Specifying [TableName]![FieldName] did not resolve the issue on the form when it was not bound to the data source.

Any ideas?