Basing one combo box on another.

[Lost]

I know that this is possible the question is . .

Is it possible to base one combo box on another in a subform in a datasheet
view.

Basically I have a form that has the clients information.
In the subform it is in datasheet view because when the database does the
survey they are able to rate two events twice. I have it set up with no
errors except that it does not give me options after i pick the first combo
box.

Any help would be helpful thank you in advance

 

[Arvin Meyer [MVP]]

Remember that a subform really isn't a form at all, it is a control with
form properties, which work only on the active record. It also has some
control properties which are independent of the form.

Therefore, changing the rowsource property of another combobox or requerying
it, has the same effect of changing every row. That means that some rows may
not have the same values for the second (dependent) combo box.

The easiest way around this is to use a small popup form to do the editing
of each row, and have it write the results back to the subform.