verify change of data (1 Viewer)

[vickiwells]

I have a combo box which is used to enter new data. However, sometimes the user accidentally changes data, when what they meant to do is filter by form. What's the best way avoid this and still be able to enter new data in the combo box? I've tried using a separate unbound combo, but it doesn't actually filter the records, it just does a GoTo.

 

[Rich]

Look at solutions enter/edit products might be a better way of what your trying to do.
HTH

 

[ntp]

Another option would be to simply inform the user that an item is going to be added. When an item is not found on the list you display a message and they can agrre to either an add, a filter or a cancel.

ntp