forms

[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?

 

[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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com