Hello All,
I am using Access 2000. I'm having a hard time
to make the Query by Form to work, here is what has been done:
Table = tblClient
Query = qryLabel
Form = frmReport
Report = rptLabel
As I understand it in the Query - criteria area for each field
of the tblClient
I insert for example [forms]![frmReport]![cboAgencyType] is null. I have already created the report named rptLabel so when I open the form frmReport I should be able to select any of the comboboxes, listbox, or textbox to build my criteria. I have
created a button to generate a report in the on-click event. I have it as:
DoCmd.OpenReport "qryLabel", acViewPreview.
My question is:
1. The Comboboxes and Listbox displays nothing for entering selection. Why?
2. Is my code "DoCmd.OpenReport "qryLabel", acViewPreview" correct for the cmd button when the user is ready to print? I don't really understand too much about the difference between the filter and where clause for the OpenReport syntax. How do I know how to choose which one?
Thanks for any suggestion, advice, and response in advance.
I am using Access 2000. I'm having a hard time
to make the Query by Form to work, here is what has been done:
Table = tblClient
Query = qryLabel
Form = frmReport
Report = rptLabel
As I understand it in the Query - criteria area for each field
of the tblClient
I insert for example [forms]![frmReport]![cboAgencyType] is null. I have already created the report named rptLabel so when I open the form frmReport I should be able to select any of the comboboxes, listbox, or textbox to build my criteria. I have
created a button to generate a report in the on-click event. I have it as:
DoCmd.OpenReport "qryLabel", acViewPreview.
My question is:
1. The Comboboxes and Listbox displays nothing for entering selection. Why?
2. Is my code "DoCmd.OpenReport "qryLabel", acViewPreview" correct for the cmd button when the user is ready to print? I don't really understand too much about the difference between the filter and where clause for the OpenReport syntax. How do I know how to choose which one?
Thanks for any suggestion, advice, and response in advance.
