EASY ONE!!! Today's date saved to table 1

[SeeWard]

Hi just need to know how to derive today's date (been using (Now()) but would rather not have the time stamp on it. I need today's date to automatically appear on the form yet be saved to the table.
TIA as always,

 

[dhookom]

Use Date() rather than Now(). You can set the default value of a text box on a form to:
Default Value: Date()


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[SeeWard]

Thanks Duane! I've done as you've instructed, but now am wondering how to bind that value to the table. I need the ddate to be autopoplated yet be saved to the table for query and date range purposes.....

 

[dhookom]

To bind a text box to a table, set the control source of the text box to a field in the table.

Do you need to set the value to the date the record was updated in addition to when the record was inserted? If so, you should try to include these requirements in your original post.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[SeeWard]

Thank you so much Duane..you've always been such a great help to me and I thank you for the time you spend on this forum. You're right, you are absolutely right about being clear as possible in the first post...but no, I don't need that field to be updated if the record itself is updated. Good point though...very good point indeed.....Thanks for your help! You just solved my problem...