Hello,
I am creating a database to view information.
I have a query called qryAll.
I have a form called frmDept.
On this form I have two cascading combo boxes. The second selection depends on the first.
In the row source for the second combo box I have the following code:
SELECT File, Description, Located, Source, Accuracy, Coord_Sys, Type, Keyword FROM qryAll WHERE Dept=Forms!frmdept!cboDept ORDER BY File;
This works VERY well for my purposes. It displays the data below from the selection made in the cascading combo boxes.
However, the form is still displaying ALL 21 of the records from the query, despite the selection made.
If no selection is made, you can scroll through the navigation buttons and look at all the different records.
However, if a selection is made, and all the data for that particular record is being displayed in the form, ALL 21 of the SAME records are displayed on the form.
I am very discouraged because it was working fine until I discovered this. I am now having problems trying to print reports because it prints all 21 records.
Anyone have a quick fix for this?
I am creating a database to view information.
I have a query called qryAll.
I have a form called frmDept.
On this form I have two cascading combo boxes. The second selection depends on the first.
In the row source for the second combo box I have the following code:
SELECT File, Description, Located, Source, Accuracy, Coord_Sys, Type, Keyword FROM qryAll WHERE Dept=Forms!frmdept!cboDept ORDER BY File;
This works VERY well for my purposes. It displays the data below from the selection made in the cascading combo boxes.
However, the form is still displaying ALL 21 of the records from the query, despite the selection made.
If no selection is made, you can scroll through the navigation buttons and look at all the different records.
However, if a selection is made, and all the data for that particular record is being displayed in the form, ALL 21 of the SAME records are displayed on the form.
I am very discouraged because it was working fine until I discovered this. I am now having problems trying to print reports because it prints all 21 records.
Anyone have a quick fix for this?
