An all in one parameter query possible? (97)

Topic

New Reply

An all in one parameter query possible?
I would like to use a default report to display results of a users search. On a form, a combo box would allow selection from one of several values, dealer#, invoice#, reference#

Reply | Quote

Replies

>>After a user selection from the combo box, a goButtonClick ought to ask for a parameter based upon the users selection from the combo box. Once the user enters that info & clicks ok, the report would pop up using the parameter info as the filter.<<

I don't really understand what you are saying here. However, you can use the WHERE clause of the DoCmd.OpenReport method to effectively filter the report contents. Is this what you are looking for?

Reply | Quote

Hi
I would try and set up unbound combo boxes:
Dealer, Ivoice, details

The contents of cbox Invoice based on a query that took the value of cboxDealer as input:

Select blah
Where varInvoice = forms!frmMyform!cboxDealer

The on Change event of cboxDealer would need to requery cboxInvoice:

frms!Myform!cboxInvoice.requery

I think this technique will work for you
Really interested in other’s ideas.
Cheers
Geof

Reply | Quote