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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to always get the top level form reference, when calling from any subform/subform... 0
Access Reference Subform's Control 0
Problems referencing Subform Control from another subform 5
Unremovable horizontal scroll bar on subform 1
Use VBA to set form control to value in a non-master/child subform? 0
Retrieve a value from an unbound control on a subform 4
open form with =>0 5
Highlight rows in a subform datasheet view 0

Back
Top