Continuous form combo issue

[CJ]

I thought I had successfully done this before but apparently not!!

Hi Groupies

My main form has a continuous subform with two combo boxes. The first combo
is a category selector, the second shows the items in that category.....no
problem there.
The issue is that when I move to the next record in the subform and select a
value from the Category combo, it changes the value in the first record.

Any idea what is going on?

Thanks for the brainwaves
CJ

 

[tina]

sounds like the Category combo box control is not bound to a field in the
form's RecordSource. take a look at the ControlSource property of the combo
box control - is it blank?

hth

 

[Svetlana]

If your combo box is unbound then that's why.

 

[CJ]

Your kidding me!!

I don't really need the category information in the results so I thought I
would just use it for criteria purposes.

Thank you both.