Combo box record source in datasheet

[Tim J]

I have a combobox on a form in datasheet view that's
record source is tied to a another control on the form.

the combo box is set to limit to list.

When the other controls value is selected the values in
the combo boxes in other records wont show if their
values are not in the new source for the current records
combobox. how do I avoid this?

TIA,
TimJ

 

[Marshall Barton]

I have a combobox on a form in datasheet view that's
record source is tied to a another control on the form.

the combo box is set to limit to list.

When the other controls value is selected the values in
the combo boxes in other records wont show if their
values are not in the new source for the current records
combobox. how do I avoid this?

You can not avoid that using a form in datasheet view.

Even in continuous view, this is a very tricky situation
involving laying a text box on top of the combo box,
modifying the form's record source query and adding a few
lines of code.

If you're willing and able to convert your form to
continuous view and want to pursue this, post back with
details about the form's record source table/query and the
combo box's row source table/query.