Form fields are null in the onLoad (or onOpen) event?

[panoss]

I have a form and in it two date fields and a subform.


I want want I open the form the subform's data to be between ta dates of the two datefields.
But when the form Opens or Loads (I tried both onLoad and onOpen events of the form) the two date fields are null (I guess they are created later).
After the form opens, I can use the two date field to filter the subform with a button.
The problem is on the form's open or load.
What can I do about this?

Edit: I also tried onCurrent event, but no success too, it's the same as the other two events.

[June7]

The two date fields are populated how? These are unbound controls to enter filter criteria?

You should know that subforms load before the main form - I know sounds backwards but it is the way it is.

Why are you using form/subform arrangement? Is the main form bound to data? If not, then use the subform independently. Continuous View can be made to look like Datasheet and this will make the form header available so the date controls can be positioned there. Can set their DefaultValue property to some date values that will encompass all records.

[panoss]

The two date fields are populated how? These are unbound controls to enter filter criteria?

They are bound to a table. I did it this way, so that they are saved.
So when the user opens the form, the last dates entered, are shown.

You should know that subforms load before the main form - I know sounds backwards but it is the way it is.

I tried both in the subform's and form's events.

Why are you using form/subform arrangement? Is the main form bound to data? If not, then use the subform independently. Continuous View can be made to look like Datasheet and this will make the form header available so the date controls can be positioned there. Can set their DefaultValue property to some date values that will encompass all records.[/QUOTE]
The main form in fact has the dates table as datasource.
I don't think the problem is that they are positioned on different forms (I mean the date fields and the subform).

[June7]

The subform loads before the main form, so even if the textboxes have dates in them the subform would not be able to filter because the textboxes are not available to the subform when it loads. Although setting the subform container Master/Child Links somehow deals with this and synchronizes the two datasets. But you are not using Master/Child Links.

What method are you using to filter the subform?

If the textboxes are blank when the form opens then it is opening to a new record row?