By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,493 Members | 3,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,493 IT Pros & Developers. It's quick & easy.

How to get a subform to take its parameter from another form?

P: n/a
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

May 6 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.