Hi every one,

I want to remove a record from a table when I select the element from a listbox. The listbox RowSourceType property is set to 2-Alias and my BoundColumn is set the field I need. The source table of the listbox has exactly the same structure as the table I'm searching into.

Why do I get an "Operator/operand type mismatch" error with the following statement:

DELETE FROM myTable WHERE id=thisform.myLstBox.value

I tried with the id field Integer and then Numeric.

Is there a problem with the returned value of a listbox.

Thank's