Combo Boxes in Sync

[Guest]

My form has two combo boxes on a form that is writing to a table. The first
is for the user to select the Director. The second selects from the Managers
reporting to the Director (selected in the first combo box). The second
combo box is based on a query which has WHERE criteria pointing to the first
combo box. It also has a macro place 'On Enter' which is RunCommand.Refresh.
This logic works perfectly if all of the required fields are already
completed or if it's the first time you are selecting a Manager. But
selection of the Director and Manager are pretty early in the form and if you
change your mind and all of the required fields are not completed, you begin
to get errors that based on the need to fill required fields. How can I
correct my logic or bypass these errors?

Thanks in advance for any help you can provide!

Cathy

 

[Rick Brandt]

My form has two combo boxes on a form that is writing to a table.
The first is for the user to select the Director. The second selects
from the Managers reporting to the Director (selected in the first
combo box). The second combo box is based on a query which has WHERE
criteria pointing to the first combo box. It also has a macro place
'On Enter' which is RunCommand.Refresh. This logic works perfectly if
all of the required fields are already completed or if it's the first
time you are selecting a Manager. But selection of the Director and
Manager are pretty early in the form and if you change your mind and
all of the required fields are not completed, you begin to get errors
that based on the need to fill required fields. How can I correct my
logic or bypass these errors?

Thanks in advance for any help you can provide!

Cathy

Why are you issuing the Refresh? If you want the list in the ComboBox to be
updated then you need...

Me!ComboBoxName.Requery

 

[Guest]

Thanks Rick! It works perfectly. Problem solved.