UPDATE tblCDDetails SET tblCDDetails.Available = "No"
WHERE (((tblCDDetails.CDNumber)=[forms]![frmLoanCD]![CDNumber]));
is what ive got, yet i get some type conversion error. basically i want it change the availability of the CD to "No" (its a yes/no field) by searching for the CDNumber and i cant whats wrong with it. i can override the error and it seems to work fine. whats a type conversion error?
thanks for any help
WHERE (((tblCDDetails.CDNumber)=[forms]![frmLoanCD]![CDNumber]));
is what ive got, yet i get some type conversion error. basically i want it change the availability of the CD to "No" (its a yes/no field) by searching for the CDNumber and i cant whats wrong with it. i can override the error and it seems to work fine. whats a type conversion error?
thanks for any help
