Linked combo boxes

[Jonathan Blitz]

I have two combo boxes on a form - both of which display data from an
SQLServer table.
The boxes need to be linked so that the second combo displays data according
to values in the first box.
In other words I need to use the value in the first box in the WHERE clause
of the second.

How do I do this?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

 

[Dirk Goldgar]

I have two combo boxes on a form - both of which display data from an
SQLServer table.
The boxes need to be linked so that the second combo displays data
according to values in the first box.
In other words I need to use the value in the first box in the WHERE
clause of the second.

How do I do this?

There are two equally workable techniques posted here:

http://www.mvps.org/access/forms/frm0028.htm