No Match Found

[Annabelle]

I have a text box which populates when you double click an item from a list box.

Likewise when you double click an item in the text box, it should remove the item.

The purpose is to select options on a vehicle in inventory. The list box shows all options available and the text box shows the options on the vehicle in our inventory.

Problem: At one point, all was working fine with this; however, now if I accidentally double click an available option and it moves to the text box of existing options on that vehicle...and I then double click to remove it from the box, I get a "No Match Found" message.

NOTE: There is a table (tblModelOptions) which populates with all options chosen as existing on models in inventory.

The ONLY time I DO NOT get a "No Match Found" message is (1) if I go to tblModelOptions and delete all selected options for models in inventory and (2) Compact and Repair Database. In this case, the FIRST and ONLY the FIRST option I select as being on a model in inventory will allow me to double click and remove it... and after that I start having the same problem again.

I will be very grateful if someone can help me solve this.

 

[Annabelle]

Is the problem that I deleted the selected options via going to tblModelOptions, highlighting all records, and deleting them, instead of double clicking the option on the form to delete it.

However, please note the reason I deleted this way was because I was getting the No Match Found message and did not know what else to do.

And now I am facing this problem. Did I delete them improperly.

 

[llkhoutx]

Try executing your code with the debugger "on" to see what it's doing.