Using the Calendar once to update all records

[dev_gordie]

Hello,
This is probably a very basic question, but I can't think how to answer it myself. I want to use the built-in calendar on a form, click it once, and set the date for ALL the records in the table because the table contains records that are part of a batch. Do I try to use the date selected as criteria in an Update Query? Do I try to use the date selected to set the DefaultValue for the field? I know that many disagree with the viability of the built-in calendar, but my question isn't really about the calendar as much as it is about transferring the data to every record.

Any help I recieve will be greatly appreciated.

Gordon

 

[pbaldy]

Setting a default value would only affect records created from that point forward, so using that value in the SET clause of an update query would be the way to go.

 

[pbaldy]

I didn't realize you'd double-posted the question, which is not good etiquette:

http://www.access-programmers.co.uk/forums/showthread.php?t=111452

 

[dev_gordie]

I apologize for double posting this item. My computer hung after I clicked the button and when I returned to post again, I went into a different section. I hadn't realized that my post was submitted twice. Very sorry.

Gordon