B
Brian
I am calling Uncle on this one. This SQL/VBA hacker has a form in which a
crosstab query is called. In the query the user is asked for a month (mmm)
and year (yyyy) for which to pull the data. Originally, after the query was
done the form would then ask the user to re-enter the month and year to
create an output file with the month and year in the name. Of course I had
the bright idea that one should be able to somehow pass the parameter from
query to form or form to query so that no re-entry was required.
Well, I tried using a separate form to capture the parameters and used that
criteria in the query [Forms]![myform]![month] etc. but the main form did not
get those parameters, even though I used 'Dim' for the parameters before any
Subs.
I am not well versed in the programming vernacular but get by. Does anyone
know of a way to 'easily' accomplish my task?
Thanks in advance for ANY help!
crosstab query is called. In the query the user is asked for a month (mmm)
and year (yyyy) for which to pull the data. Originally, after the query was
done the form would then ask the user to re-enter the month and year to
create an output file with the month and year in the name. Of course I had
the bright idea that one should be able to somehow pass the parameter from
query to form or form to query so that no re-entry was required.
Well, I tried using a separate form to capture the parameters and used that
criteria in the query [Forms]![myform]![month] etc. but the main form did not
get those parameters, even though I used 'Dim' for the parameters before any
Subs.
I am not well versed in the programming vernacular but get by. Does anyone
know of a way to 'easily' accomplish my task?
Thanks in advance for ANY help!