Continuous Forms (Access 2003)

Topic

New Reply

I have two combo boxes on a continuous form. I would like for the selections of the second to be dependant on the first. I have set the row source of the second to use the value of the first as a criteria in the query.

The problem is when I choose a new value on one row of the form, all the rows change.
I know there should be a way to do this, I just have not found it so far.

Ideas???

Thanks

Reply | Quote

Replies

In a setup with cascading combo boxes, as they are called, the first combo box is usually unbound (i.e. its control source is blank). In a continuous form, this will cause the combo box to act the same for all displayed records. The thread starting ar post 340270 describes a way to get around this, by placing a text box on top of the combo box.

Reply | Quote

Thanks Hans

That works great

Reply | Quote