Code not working with tab control

[pg13Reader]

Hi there!
I have several forms and want to capture some data as an audit trail of when a change was made to a record. The following works in one of my forms:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.DateEdited = Now()
End Sub

Very simple and works beautifully.

But the form where I have an tab control it doesn’t work. I tried using a reference to the table, such as: Me.t_Clients.DateEdited = Now()
and get the following Visual Basic error:
Compile error – method or data member not found.

Compiling gives me the same error.
Does anyone know what am I doing wrong?
Thank you!!

[boblarson]

Tab controls have no bearing on referencing items on them UNLESS you have a subform on the tab control and then it is only the subform control (control on the parent form which houses the subform) you have to worry about.

If you aren't using a subform, then the reference would be the same. If you ARE using a subform then you would need to reference the control like:

Me.SubformControlNameHere.Form.DateEdited = Now()

where SubformControlNameHere is the name of the actual subform control on the main form which houses the subform on it, and not the name of the subform itself UNLESS the subform control and the subform share the exact same name. The .Form. part is necessary to tell Access you want to refer to something on the subform and not the subform control.

[pg13Reader]

Hi Bob, Thanks for the suggestion, but it's the main form that has the fields I'm trying to update. I made a copy of the form and removed the tab control, thinking I was back to the basics with the form, but it's still giving me the same error. There is a combo box, pulling data from another table that also has the same field name (prefer not the have different names here). Adding the reference to the specific table/field doesn't seem to work. Any other ideas?
Many thanks!

[boblarson]

Make sure that the control name and the field name (that the control is bound to) are not the same. Then refer to the control name.

[pg13Reader]

That was the trick! I didn't have those fields on the form, but since this works I'll use it. They can be hidden, right?
Thank you very much!! I was pulling out lots of hair on this one.