Form that Auto Fills Current Date, but does not show up in Query

  • Thread starter Thread starter Shayster
  • Start date Start date
S

Shayster

I have a form used for tracking sales orders that has a field for "Date
Entered". That used to be a manual entry and we were asked to make that an
auto fill. We didn't realize though, that the auto fill is not making it's
way to the Query for the related for or to the Table for that matter. I
think the issue might be b/c the Date Entered Field now has an expression in
it, =Date(), and from what I've read that will only show in the form b/c it's
like a formula which we are supposed to write in queries... I tried to put
the expression into my query, but that didn't work either. Any ideas? Thanks!
 
I have a form used for tracking sales orders that has a field for "Date
Entered". That used to be a manual entry and we were asked to make that an
auto fill. We didn't realize though, that the auto fill is not making it's
way to the Query for the related for or to the Table for that matter. I
think the issue might be b/c the Date Entered Field now has an expression in
it, =Date(), and from what I've read that will only show in the form b/c it's
like a formula which we are supposed to write in queries... I tried to put
the expression into my query, but that didn't work either. Any ideas? Thanks!
Click to expand...

The Control Source of a control can be either the name of a table field (in
which case data entered into the textbox is stored in that field), *OR* it can
be an expression such as =Date(). In the latter case nothing gets stored
anywhere.

Restore the Control Source of this control to the name of the [Date Entered]
field, and set its DefaultValue property to =Date(). This will allow the user
to accept the current date, *or* overtype it with some other date; and it will
also store that date in the table and display existing records' date.
 
Back
Top