Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Type mismatch error from listbox.value
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement