Combo Box

[Dorian C. Chalom]

I have a Combo Box based on another Combo Box and it works fine as long as
there are records to populate the second combobox. If there are no records
to Populate the second ComboBox then it seems it is not updated.

How do i make it update with a null list?

 

[Jeff Boyce]

Dorian

I'm not following...

If there are no records to populate Combobox2, what do you mean by "make it
update with a null list"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dorian C. Chalom]

OK
The Data is like this...

ComboBox1 ComboBox2
AAA AAA1
AAA AAA2
BBB

When I select AAA in ComboBox 1 I see AAA1 and AAA2 in ComboBox2
Then when I select BBB in ComboBox 1 I still see AAA1 and AAA2 in ComboBox
2.
I should not.

Does that explain it better?

 

[Ron2006]

In the afterupdate event for combo1 are you doing a requery of combo2?

That should be done.

Ron

 

[Dorian C. Chalom]

OK I did that still the same results...

 

[Dorian C. Chalom]

Never mind I got it my where clause was not using the form field.

Thank you.