Hello - 

I am trying to requery the values that show in ComboBox 2 based the value 
that is selected in ComboBox 1. 

Combo Box 2 values work when you first go to a new record and select a value 
in ComboBox 1, but if you decide to go back and change the value in ComboBox 
1, the old list of values are still in ComboBox  2

Some of the fields on this form do not allow NULLs and the ReQuery or 
Refresh commands are giving me an ODBC error. 

How do I refresh the values in ComboBox 2 ONLY without having to put data in 
all the fields first?

I am using the following Event on the OnExit of ComboBox 1

DoCmd.Requery ([ComboBox2])


Thanks for your help.

sandy

When you change the value in combo1, combo2 will not requery automatically, 
you have to make it do it yourself. Code an AFTER UPDATE event for combo1 
with a requery:
Me!Combo2.Requery

-Dorian

"Sandy" wrote:

> Hello - 
> 
> I am trying to requery the values that show in ComboBox 2 based the value 
> that is selected in ComboBox 1. 
> 
> Combo Box 2 values work when you first go to a new record and select a value 
> in ComboBox 1, but if you decide to go back and change the value in ComboBox 
> 1, the old list of values are still in ComboBox  2
> 
> Some of the fields on this form do not allow NULLs and the ReQuery or 
> Refresh commands are giving me an ODBC error. 
> 
> How do I refresh the values in ComboBox 2 ONLY without having to put data in 
> all the fields first?
> 
> I am using the following Event on the OnExit of ComboBox 1
> 
> DoCmd.Requery ([ComboBox2])
> 
> 
> Thanks for your help.
> 
> sandy
> 
> 
> 
>