audit record date - updating table only

  • Thread starter Thread starter Meryl
  • Start date Start date
M

Meryl

Hi,

Is there a way to update an underlying table without
placing the field in the form? I don't want the field
displayed on the form.

I would like to update a date field each time a record is
updated (in the before update event). However, the only
way that I know to do this, is to place the date field on
the form and set visible to "no". I would like to update
the field without having to place it on the form
altogether. Is this possible? And if so, can you give me
the code?

thx.
 
The code in Form_BeforeUpdate will work even if the field is not represented
by a control on the form. The field just has to be present in the
RecordSource of the form (whether that is a table or query).

If you still have trouble getting it to work without the control, you could
always set the Visible property of the text box to No, so that is can only
be seen in design view.
 
Back
Top