Prev: #name? error
Next: List Box Percentage Formatting
From: PleaseHelpMe on 13 May 2010 13:36
I hope this makes sense...

My frmEmployeeMain contains one subform, frmProbation. Within frmProbation,
there are three subforms, frmProb1, frmProb2, frmProb3. Each of these three
subforms has a CompletionDate field. These three subforms were created by
three queries from ONE table, tblProbation.

The frmEmployeeMain was created from tblEmployeeInfo. In tblEmployeeInfo and
frmEmployeeMain, there is a LastReportReceived field.

The EmployeeID is the related record in all these forms and tables.

Is it possible to automatically populate the LastReportReceived field with
the most current date entered in any of the three Prob subforms, and also
allow the LastReportReceived field to be edited?

From: Jeanette Cunningham on 13 May 2010 21:46
You can use the after update event of each subform to set the date on the
main form.

Code the after update event of each subform would be something like this,
Me.Parent.DateControlName = Me.DateControlName

To make sure you get the most recent date, something like this:

If Not IsNull(Me.Parent.DateControlName) Then
If Me.DateControlName > Me.Parent.DateControlName Then
Me.Parent.DateControlName = Me.DateControlName
End If
Else
Me.Parent.DateControlName = Me.DateControlName
End If

Note: replace my object names with your own names.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"PleaseHelpMe" <PleaseHelpMe(a)discussions.microsoft.com> wrote in message
news:D367DAC4-E79C-4A49-9EE0-28088774347D(a)microsoft.com...
>I hope this makes sense...
>
> My frmEmployeeMain contains one subform, frmProbation. Within
> frmProbation,
> there are three subforms, frmProb1, frmProb2, frmProb3. Each of these
> three
> subforms has a CompletionDate field. These three subforms were created by
> three queries from ONE table, tblProbation.
>
> The frmEmployeeMain was created from tblEmployeeInfo. In tblEmployeeInfo
> and
> frmEmployeeMain, there is a LastReportReceived field.
>
> The EmployeeID is the related record in all these forms and tables.
>
> Is it possible to automatically populate the LastReportReceived field with
> the most current date entered in any of the three Prob subforms, and also
> allow the LastReportReceived field to be edited?
>


 | 
Pages: 1
Prev: #name? error
Next: List Box Percentage Formatting