Z
Zoltar54
I have a form that contains 2 cmb's (cmbActReg and cmbSection) and 1 textbox
(txtDescription). What I am trying to do is have the second combobox display
a number of items based on a selection made in the First box. I have found
an example on MSDN regarding this and have followed it step by step but it
still does not seem to work.
My Form is called "Offence Details".
This form is based off of two tables
1) Act/Regs - this table contains 22 seperate acts and/or regulations.
2) Legislation - this table contains the various sections of the 22 act/regs
listed in the previous table.
I have a 1-to-many relationship between the Act/Reg and Legislations tables
based on the ID (primary key) in the Act/Reg table (the foreign key in the
Legislation table is called ActRegID).
On the Form I have set the RowSource properties of cmbActReg to:
SELECT [Acts/Regs].ID, [Acts/Regs].[Acts and Regulations] FROM [Acts/Regs];
For cmbSection the RowSource properties are set as:
SELECT Legislation.ID, Legislation.ActRegID, Legislation.Section FROM
Legislation WHERE (((Legislation.ActRegID)=forms![Warnings
Issued]!cmbActReg)) ORDER BY Legislation.Section;
When I open the form I am prompted to enter the criteirs for the above
queries. When I enter the information noting happens.
Can someone provide somw assistance with this? What I woudl like to have
happen is that the query is run automatically (as it was in the example I
read on the Web).
Z
(txtDescription). What I am trying to do is have the second combobox display
a number of items based on a selection made in the First box. I have found
an example on MSDN regarding this and have followed it step by step but it
still does not seem to work.
My Form is called "Offence Details".
This form is based off of two tables
1) Act/Regs - this table contains 22 seperate acts and/or regulations.
2) Legislation - this table contains the various sections of the 22 act/regs
listed in the previous table.
I have a 1-to-many relationship between the Act/Reg and Legislations tables
based on the ID (primary key) in the Act/Reg table (the foreign key in the
Legislation table is called ActRegID).
On the Form I have set the RowSource properties of cmbActReg to:
SELECT [Acts/Regs].ID, [Acts/Regs].[Acts and Regulations] FROM [Acts/Regs];
For cmbSection the RowSource properties are set as:
SELECT Legislation.ID, Legislation.ActRegID, Legislation.Section FROM
Legislation WHERE (((Legislation.ActRegID)=forms![Warnings
Issued]!cmbActReg)) ORDER BY Legislation.Section;
When I open the form I am prompted to enter the criteirs for the above
queries. When I enter the information noting happens.
Can someone provide somw assistance with this? What I woudl like to have
happen is that the query is run automatically (as it was in the example I
read on the Web).
Z