Update Query

[Hayvek]

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

 

[ColinEssex]

It means that you're trying to enter the wrong type of data to a field. i.e. text to number or whatever.

Col

 

[Hayvek]

hmmm so its trying to update my CDNumber field to "no" yes? which it cant do because thats an autonumber

 

[ColinEssex]

Yep

 

[Hayvek]

sorted needed a 0 instead of the "no"