Hi All,
I need help with Microsoft Access.
Here's the scenario;
I have created two tables one called tbl_tests with one column called test list, the second table called tbl_sent to with two columns called Location and Code.
I have created a form with two combo boxes, one for each table, called cmb.tests and cmb.sent to.
I would like to link them together so when the user selects the relevant choice from cmb.tests it will automatically change the list in cmb.sent to.
The sent to box doesnt need to be a combo box I could change it to a text box so when the user selects from cmb.tests it will add the location.
I would appreciate any help you can give me on this problem.
Spike
I need help with Microsoft Access.
Here's the scenario;
I have created two tables one called tbl_tests with one column called test list, the second table called tbl_sent to with two columns called Location and Code.
I have created a form with two combo boxes, one for each table, called cmb.tests and cmb.sent to.
I would like to link them together so when the user selects the relevant choice from cmb.tests it will automatically change the list in cmb.sent to.
The sent to box doesnt need to be a combo box I could change it to a text box so when the user selects from cmb.tests it will add the location.
I would appreciate any help you can give me on this problem.
Spike