Cascading Combo Box - 2nd combo box changing 1st in previous recor

Cascading Combo Box - 2nd combo box changing 1st in previous recor

Post by U2FyYW » Tue, 24 Nov 2009 12:29:01


I have figured out how to creat cascading combo boxes, however once i update
the second combo box it changes all records on the form.

How do i get it so all records are independent from eachother?

I am somewhat new to this - any help is appreciated!
 
 
 

Cascading Combo Box - 2nd combo box changing 1st in previous recor

Post by John W. Vi » Tue, 24 Nov 2009 14:37:50

On Sun, 22 Nov 2009 19:29:01 -0800, Sarah < XXXX@XXXXX.COM >



My guess is that the second combo box is unbound: has nothing in its Control
Source field. If that's the case, on a continuous form you will see the same
value in every record.

Data is not stored in forms but in Tables - what's the Recordsource of this
form? What field (*in the table*) is intended to contain the second combo's
selection?
--

John W. Vinson [MVP]