L
lizo.consulting
I have a combo box on located a subform, with the listsource of list
contained in a separate table. The Limit to list property is set to
Yes, both in the table and the subform.
All is well until the users pastes a batch of data from excel into the
subform (this is by design, and a possible functionality we are hoping
for). However, data pasted into the combobox field is accepted even if
the text does not match a list in the source table.
Any suggestions on controlling/overriding this behavior? I'm hoping to
ensuring that the data is valid, even when pasted from an external
data source...
Thanks.
contained in a separate table. The Limit to list property is set to
Yes, both in the table and the subform.
All is well until the users pastes a batch of data from excel into the
subform (this is by design, and a possible functionality we are hoping
for). However, data pasted into the combobox field is accepted even if
the text does not match a list in the source table.
Any suggestions on controlling/overriding this behavior? I'm hoping to
ensuring that the data is valid, even when pasted from an external
data source...
Thanks.