Access 2003

[JAS]

I want to use a lookup table to fill a number of boxes on a form.
I have created a combo box from where I pick the initial info, and once
picked the other text should be filled in. How do I go about this?

 

[Wayne-I-M]

Hi

If they are bound controls (text boxes) use the AfterUpdate event of the combo

Private Sub ComboName_AfterUpdate()
Me.ControlName1 = Me.ComboName.Column(1)
Me.ControlName2 = Me.ComboName.Column(2)
Me.ControlName3 = Me.ComboName.Column(3)
'ect'
End Sub

If they are not bound to a table field you could just use
= ComboName.Column(3)
as the control source for the text boxes

Hope this helps

 

[JAS]

Thanks Wayne,
Just what I required.

JAS

Hi

If they are bound controls (text boxes) use the AfterUpdate event of the combo

Private Sub ComboName_AfterUpdate()
Me.ControlName1 = Me.ComboName.Column(1)
Me.ControlName2 = Me.ComboName.Column(2)
Me.ControlName3 = Me.ComboName.Column(3)
'ect'
End Sub

If they are not bound to a table field you could just use
= ComboName.Column(3)
as the control source for the text boxes

Hope this helps