Hi,
I am using Access 2003 and I need to link three combo boxes on a form. I have a form ‘mform’ linked to a table called ‘mtable’ the table has four columns ‘manufacturer code’ ‘manufacturers name’, ‘make’, and ‘model’. The table contains hundreds of manufacturers and each manufacturer can have several make and model of an item. On the form I will like three separate fields (dropdown boxes). The first dropdown box will be linked to a query that will show all the manufacturers in the table for the user to choose. In the second dropdown box I would like only all the ‘make’ rows for that manufacturer chosen in the first dropdown list (manufacturer name) to be automatically displayed in the second dropdown field based on the ‘manufacturer code’ (primary key) from the first dropdown list. I would also like the cursor to jump to that field (make field) and expand the choices in the next field that is now available for that manufacturer. I would like the same principle incorporated into the final field (model). What sort of coding would I need to get started with this process? Thanks.
Mtable:
Manufacturer_code
Manufacturer_name
Make
Model
Mform dropdown fields:
Manufacturer_name
Make
Model
I am using Access 2003 and I need to link three combo boxes on a form. I have a form ‘mform’ linked to a table called ‘mtable’ the table has four columns ‘manufacturer code’ ‘manufacturers name’, ‘make’, and ‘model’. The table contains hundreds of manufacturers and each manufacturer can have several make and model of an item. On the form I will like three separate fields (dropdown boxes). The first dropdown box will be linked to a query that will show all the manufacturers in the table for the user to choose. In the second dropdown box I would like only all the ‘make’ rows for that manufacturer chosen in the first dropdown list (manufacturer name) to be automatically displayed in the second dropdown field based on the ‘manufacturer code’ (primary key) from the first dropdown list. I would also like the cursor to jump to that field (make field) and expand the choices in the next field that is now available for that manufacturer. I would like the same principle incorporated into the final field (model). What sort of coding would I need to get started with this process? Thanks.
Mtable:
Manufacturer_code
Manufacturer_name
Make
Model
Mform dropdown fields:
Manufacturer_name
Make
Model
