Combo box populated from another combo box

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

Running Office XP
Could someone point me in the direction to populate a second combo box from
the results from the first combo box on the same form. I know this is done
in the Northwind DB using supplier and category but can't locate the code or
macros to make it run. Access 97 did have detailed instructions on how to
perform this also but alas has been lost over time.

Thanks in advance.
 
-----Original Message-----
Running Office XP
Could someone point me in the direction to populate a second combo box from
the results from the first combo box on the same form. I know this is done
in the Northwind DB using supplier and category but can't locate the code or
macros to make it run. Access 97 did have detailed instructions on how to
perform this also but alas has been lost over time.

Thanks in advance.
--
Regards
Grant


.Your second combo box should be based on a query that
Click to expand...
includes the table or query that you used on the first
combo box. Then include the field from the first combo box
and in the criteria field used the value of the first
combo box. You will have to put me.requery in the after
update event of the first combo box to make it work if the
user changes their selection.
 
Thankyou all for your help

PS I found the A97 file - Solutions.mdb - may be old but still some great
information in it.
 
Back
Top