Hi guys!
I have created a query that gets its parameters from a form, but did not like the standard output that the query presented me with. I therefore decided to create a form based on the query, that displays the results in a format that I like. If i double-click the queryform, it displays the prompts for the values that I have to enter (a range query) but I can't seem to figure out how to link the original dialog that passes the parameters to the query into the whole thing.
I.E:
parameterform ----> query ----> outputs to my custom form
^
this is the part I'm missing
My query has as its criteria ' between [forms]![parameterform]![fromvalue]
and [forms]![parameterform]![tovalue]'
So how can I link this? Any help would be greatly appreciated.
Regards
Ruan
I have created a query that gets its parameters from a form, but did not like the standard output that the query presented me with. I therefore decided to create a form based on the query, that displays the results in a format that I like. If i double-click the queryform, it displays the prompts for the values that I have to enter (a range query) but I can't seem to figure out how to link the original dialog that passes the parameters to the query into the whole thing.
I.E:
parameterform ----> query ----> outputs to my custom form
^
this is the part I'm missing
My query has as its criteria ' between [forms]![parameterform]![fromvalue]
and [forms]![parameterform]![tovalue]'
So how can I link this? Any help would be greatly appreciated.
Regards
Ruan