Subform Tabs - Field to Field Auto Populate

[Beeyen]

Good Day

I am trying to auto populate a field in one subform tab with the
information, which happens to be date and time, in the field of from another
subform tab and was hoping I could received some assistance.

In a subform tab called Production I have a field called Production
Completed which when selected through a radio button enters the current date
with the following code:

Private Sub ProductionCompletedButton_AfterUpdate()
If Me.ProductionCompletedButton.Value = True Then
Me.[ProductionCompleted] = Now()
Else
Me.[ProductionCompleted] = Null

End If

End Sub

In another subform tab called Quality Assurance, I have a field called
Received from Production in which I would like to have auto populated the
same date from the field Production Completed in the Production tab.

Thanks for any assistance you can provide

 

[Jeanette Cunningham]

Hi Beeyen,
you could try an unbound textbox on the main form with its format set to
short date.
In the after update event for the form of the production tab, you would set
the unbound text box on the main form to the value for production completed.
When you open the quality assurance tab, it could grab the date from the
textbox on the main form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia