Refer Subform Control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, using Access 2003, I like “DPN†to be populated in Form [ReceivingLog14]
control [TransActionType15] when data is inputted in ReceivingLog14 Subform
[DeptNonStock Number Subform] control [Description]. Thank you for your
assistance.
 
D. Green,

Do you mean that whenever there is any data at all in [Description] that
the [TransActionType15] should read "DPN"? Well, I suppose you could do
code like this on the After Update event of [Description]...

If Not IsNull(Me.Description) Then
Me.Parent!TransActionType15 = "DPN"
End If

If you needed TransActionType15 to be cleared if the entry in
Description was deleted, maybe like this...

If Not IsNull(Me.Description) Then
Me.Parent!TransActionType15 = "DPN"
Else
Me.Parent!TransActionType15 = Null
End If
 
Back
Top