Combo Box Change Value Problem

[James McNellis]

Hello all--

I have a continuous forms form. It has a combo box in the header that is
used to filter the values shown in another combo box that is in the detail.
So, when I change the value in the header combo box, the values shown in the
detail combo box are changed.

I needed this because that header combo box acts also as a filter for the
entire form, and when it changes the records on the form, it needs to
change the items in the combo box as well.

This now works perfectly, thanks to suggestions provided by the group
earlier.

The problem I am having now is that I cannot change the value in this combo
box. I can change the values of all other form fields in the detail except
for this one. It is enabled and not locked. I can add, modify, and remove
records, but I cannot edit this form.

Any suggestions?

Thanks in advance for the assistance again.

Cheers--

James.

I apologize for posting again, if I am. I saw my post before, but then it
was marked as deleted in Outlook Express.

 

[Guest]

Exactly how are you using Combo1 to set the value in Combo2? If Combo2 has a
ControlSource that is something like: =[Combo1] * 2, then you will not be
able to change it because its value is always tied to Combo1.

Make sure that it is the RowSource and not the Control Source of Combo2 that
is being set by Combo1.

Also, if Limit To List is turned on for Combo2, it will not allow entries
other than those within the scope of the filter Combo1 provides.