forms

A

af01waco

i am wanting to have my form display information in one control that is
linked to another control. In other words, the first control, i enter a name,
in the second control that persons account number appears. Is this possible?
 
L

Linq Adams via AccessMonster.com

I think this is whaat you want:
Private Sub YourNameTextbox_AfterUpdate()

Me.AcctNumber = DLookup("[AcctNumberField]", "YouTableName", "[YourNameField]
= '" & Me.YourNameTextbox & "'")

End Sub
 
Top