Update Query

[toddbingham]

WHen creating an update query, there has to be a value in the Update To field. How do I get that to prompt me for a value. I have tried the standard [Enter Date], that does not prompt me for a value.

Thanks.

 

[GumbyD]

I tried it here on Access 2000 without an issue. You may have to add the to the parameters to the query by right clicking in the query design and selecting parameters. Make sure your datatype is date/time. The other thing to check is that the field you are updating is a date/time data type as well.

GumbyD

 

[toddbingham]

Ok, I did that and it worked. Now, How to I get a check box to update with an update query?

Thanks.

 

[toddbingham]

Nevermind, just put True in the update field. Duh.