Combo box populated from another combo box

[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.

 

[Alan Fisher]

-----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

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.

 

[RobFMS]

You need to be careful about doing this. Take a look at this to help give
you an idea of what to expect.

Data in a combo box control on a continuous form/datasheet disappears
http://www.fmsinc.com/free/tips.html#tip16foraccess

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Grant]

Thankyou all for your help

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