I have a form [UnbilledWork] which contains two subforms:
[UnbilledHours] and [UnbilledExpenses].
The two subforms each have a SQL query to display their results in
datasheet view and allow the user to tick which items have been
billed.
What I'm trying to do is to use another form [End Date] to prompt the
user for the ending date. The date entered is then used as the
parameter in the subform SQL queries.
I'm trying to get the [End Date] form to come up first, prompt the
user for the desired date, then use this in the subform queries.
My issue is that forms appear to load the subforms first, then the
master form. As such, if I open my [End Date] form using the Open
event of [UnbilledWork], it's too late because the subforms are opened
first and they prompt for missing parameter values.
I tried opening the [End Date] form using the Open event of the
subforms, but that doesn't seem to work either.
Is there any easy way to open my [End Date] form, get the desired
value, then open the master and subforms so that the subforms
parameter will be available?
At present, the only way around this is to open another report or form
that uses the [End Date] form, enter a date, view the form or report,
then close it and go back to my [UnbilledWork] form (because then the
[End Date] form will remember what was entered previously and won't
prompt for any missing parameters).
tia
Jeff