Synchronising updates on subform with main form

[cath_hopes]

hi there!

I have a subform imbedded in a main form. The main form has a one to many relationship with the details in the subform. The subform's properties are set to Single Form rather than Continuous Form.

The main form is a Booking Form and the subform is a booking status form with the possibility of several booking status records attached to one booking record.

I have a 'Save' button on the main form which has the following code attached to it:

Me.Booking_last_updated_at.Value = Date + Time

I would like to add some code to simultaneously update a date field on the subform record that is currently displayed. I have tried the following code:

Forms![Booking Status].[Booking Status Date].Value = Date + Time

but when I tested this I got the runtime 2450 error message that Microsoft Office Access can't find the form 'Booking Status' referred to in the macro or Visual Basic code.

Any help with this would be much appreciated!

 

[RuralGuy]

Are you aware that Now() stores both Date and Time? See if this link helps with referencing the control on your SubForm. Refer to Form and Subform properties and controls

 

[cath_hopes]

Fantastic! My subform and mainform are now synchronised using VBA. I've also used Now() which I wasn't aware of before.
Thanks for both that tip and the link.

 

[RuralGuy]

You're very welcome. Glad I could help.