Slow Defaults in New Record

[jwstockwell]

ACCESS2000

I have a form with four pages and subforms on Pages2-4. Page1 has 5 controls bound to fields from a SQL query from one table. Pages2-4 have fields bound to other more complex queries. When a new record is added for Page1 only 1 of three default values show up in the controls initially. All three fields are date/time. The other fields are dropdowns. If I make a pick from either of the dropdowns both of the missing defaults are updated properly.

I have tested via a simple form with one page and the same SQL rowsource and this simpler form works fine - new record shows all defaults immediately.

Any ideas?

TIA

 

[jwstockwell]

Sorry guys - Stupid programmer trick - I had bound them to the fields in the table somewhere along the line, not to the query.