I have two comboboxes in a subform .
The problem is that the second combo that is populated from the first combo value fills all the columns on the continuous forms.

What am i doing wrong?

Make sure your subform uses the 2nd combo box as a criteria to limit the number of records selected.

And make sure you're reqrying the subform after the selection is made in the 2nd cbo.

Steve

Hi thanks for your reply
I do that but it Requeries all the records in the subform after the selection.
I only want to requery one, the current record

Not sure what else I can offer . . . I usually use listboxes that drill down into bound forms then reqry the listbox on the calling form when closing the bound form.

If the current record is in a list of records on the subform, I'm not sure you can reqry it specifically . . . but I'm not sure since I don't use this method frequently.

Mabye somebody else has some thoughts . . .

Steve

Thanks anyway.
I thought it was something easy.

Pleae I still have that problem.
Can anybody help???