Hey
I have a combobox selection for a field in tblInput where the user can also type in a selection not from the list. When an item from the list is selected other fields in tblInput automatically populate. The problems is whenever the user inputs text an error comes up.
To invoke the autopopulate of fields in tblInput I've put this code in the change event:
Me.MaterialUnit.Value = Me.MaterialName.Column(2)
where MaterialName is the list selection.
I'd like to change the code so that there is an iif function where:
iff(field (typed or selected) is in the referenced list, autopopulate, do nothing)
Thanks for the help.
I have a combobox selection for a field in tblInput where the user can also type in a selection not from the list. When an item from the list is selected other fields in tblInput automatically populate. The problems is whenever the user inputs text an error comes up.
To invoke the autopopulate of fields in tblInput I've put this code in the change event:
Me.MaterialUnit.Value = Me.MaterialName.Column(2)
where MaterialName is the list selection.
I'd like to change the code so that there is an iif function where:
iff(field (typed or selected) is in the referenced list, autopopulate, do nothing)
Thanks for the help.
