Hi,
I have a form called 'CustomerContact'.
I have a table which holds a list of High Level Reasons called 'HighLevelDrivers'. A combo box named 'Highleveldriver' is used to select one of these high level drivers. The table is selected in the Row Source. In another table I have called 'ComplaintDrivers' is has the high level drivers in column 1 and low level drives in column 2.
What I need is when the high level driver is selected the low level drivers are automatically populated (in combo box LowLevelDrivers) I've tried using a query to do this, both the above columns are selected and I have in the criteria for high level "Forms!CustomerContact!LowLevelDrivers"
It is not finding the value which is selected, whereas when the form is closed and the query is ran and I manually type the value in the query pulls back the values. What am I missing?
I have a form called 'CustomerContact'.
I have a table which holds a list of High Level Reasons called 'HighLevelDrivers'. A combo box named 'Highleveldriver' is used to select one of these high level drivers. The table is selected in the Row Source. In another table I have called 'ComplaintDrivers' is has the high level drivers in column 1 and low level drives in column 2.
What I need is when the high level driver is selected the low level drivers are automatically populated (in combo box LowLevelDrivers) I've tried using a query to do this, both the above columns are selected and I have in the criteria for high level "Forms!CustomerContact!LowLevelDrivers"
It is not finding the value which is selected, whereas when the form is closed and the query is ran and I manually type the value in the query pulls back the values. What am I missing?
