Access 2003

J

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

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
 
J

JAS

Thanks Wayne,
Just what I required.

JAS

Wayne-I-M said:
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
Click to expand...
 
Top