Ok, this is a newbie question . . . I need to make a query that will prompts for a name then change a check box for that record.

What I have is:

UPDATE tblCustomer
SET tblCustomer.CreditHold = "no"
WHERE (((tblCustomer.CustomerName)="“*”" & [Enter customer name or leave blank for all] & "“*”"))
;

And when I take out "*"& and & "*" it works if I put in a customer name it works fine. But not if I don't enter a name. The table and field names are correct, but I don't know what I am doing wrong.

I am using 2008 but created it as 2003 since that is what we have use at school.

Does anyone have any suggestions?

J,

Use Like instead of =.

Wayne

Thank you very much. I have been trying to figure that out for a few days, I just wasn't thinking in the correct direction.


Is there a good book that I can get, like a good reference, something to go along with my text book?

Yeah, this works good if you want to start programming...

http://www.amazon.com/Access-2003-Programmers-Reference-Programmer/dp/0764559036/ref=sr_1_6?ie=UTF8&s=books&qid=1201990824&sr=8-6

And for the Access program specifically, I like the Bibles:

http://www.amazon.com/Access-2003-Bible-Cary-Prague/dp/0764539868/ref=sr_1_10?ie=UTF8&s=books&qid=1201990917&sr=1-10