Main form and subform - pass two separate values

[Delta729]

Hopefully that title makes sense.


I have a main form called "Task Details" which has a subform called "tblTaskTimes subform". What I'm trying to do is two fold. This portion works fine: It changes the "Status value to "In Progress".

Private Sub cmdStart_Click()
Me.Status.Value = "In Progress"
End Sub

On the subform is a "Start" field which I'd like to add the Now() function too as well, but I can't figure out how to do this.

Any help would be appreciated, even pointing towards an article that explains this with examples. (Very much a novice here, so I need examples or I'll never get it.)

[June7]

Start button is on the main form?

If you want to populate field in subform for the current record, code on main form would refer to the subform container. I always name subform container different from the object it contains, like ctrDetails.

Me.ctrDetails!Start = Now()

[orange]

Do you have tables and relationships? If so, can you show us a jpg of you relationships window?

Always start with a description of the "business" and the underlying "business rules".
Build a data model; build some test data; validate your data model; then build the database.
See this link for a basic approach to designing a database.

Good luck.

[Delta729]

OMG, thanks June, you've done it again. That was too easy. Everything I kept finding online was making it way more difficult.