Linked combo boxes

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

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."
 
Jonathan Blitz said:
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?
Click to expand...

There are two equally workable techniques posted here:

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