Auto Date in Subform

  • Thread starter Thread starter Angus
  • Start date Start date
A

Angus

I put in the line suggested into the comments field but
this had no effect.

Thus in the "txtcomments" field in the "on update" I
wrote:

me!txtDate = Date

Does anyone know why this would not have worked?

-----------------------------------------------------------
------------------

Hi Angus,
You might try putting the following into the after
update event of your comments field:
me!txtDateFieldName = Date

The Easy Day
-----Original Message-----
I'm creating a database with customer information.

In this form there is a subform with "comments" and a date
field the user can enter about any particular customer.

Rather than have the operater enter the date I want this
to auto-enter on every new comment.

Also I would like the auto date on "comments" to update if
the comment is changed.Can anyone help me with this?

Angus
 
Angus said:
I put in the line suggested into the comments field but
this had no effect.

Thus in the "txtcomments" field in the "on update" I
wrote:

me!txtDate = Date

Does anyone know why this would not have worked?
Click to expand...

That's not how event code is used. In the event property you enter "[Event
Procedure]" (without the quotes). Then you click on the build button to the
right of the property [...]. That will take you to the code module window
for your form and THAT is where you enter your code lines.
 
Back
Top