G
Guest
I have a combo box (on a continuous form) that has two columns: Column1, zero
length, bound to a field in a table, & Column2, unbound but visible. Limit to
List is True.
Now I want to filter the RowSource to only active records (Active is a
Yes/No field in the table). The filter is easy enough (Where Not Active), but
then, of course, the box is empty for any records for which that entry is not
Active.
Where I have this issue on a Single Form, I just omit the Where Not Active
clause if Active is false for the current record. I can't think of a clever
way to do this on a continous form, though.
Is the only solution to set LimitToList to False and then either:
1. Add code to the combo box's BeforeUpdate to cancel if the entry is
invalid or
2. Deal with the error generated before the form is updated (since this
field in the form's RecordSource has an enforced relationship with the
cognate field in the RowSource table)?
I know it is inconsistent with LimitToList, but is there some way to show
the field contents of an existing record even when it is filtered out of the
RowSource?
length, bound to a field in a table, & Column2, unbound but visible. Limit to
List is True.
Now I want to filter the RowSource to only active records (Active is a
Yes/No field in the table). The filter is easy enough (Where Not Active), but
then, of course, the box is empty for any records for which that entry is not
Active.
Where I have this issue on a Single Form, I just omit the Where Not Active
clause if Active is false for the current record. I can't think of a clever
way to do this on a continous form, though.
Is the only solution to set LimitToList to False and then either:
1. Add code to the combo box's BeforeUpdate to cancel if the entry is
invalid or
2. Deal with the error generated before the form is updated (since this
field in the form's RecordSource has an enforced relationship with the
cognate field in the RowSource table)?
I know it is inconsistent with LimitToList, but is there some way to show
the field contents of an existing record even when it is filtered out of the
RowSource?