Combo box help

[MLife]

Hi,ive got an order form with a subform,the subform and form are based on different tables,the subform refers to the item table,ive created a combo box to select an item and i want the rest of the details of that item to be filled in automatically.....any help appreciated

thanks

 

[MLife]

anyone? please?

 

[directormac]

This "problem" is solved for you if you use the wizard, and has been answered many times over in these forums, not to mention in Access Help and the Northwinds sample. Northwinds is probably the quickest resource, you can just copy what's there.

--RTFMac

 

[summer]

In AfterUpdate event, do an event procedure:

YourComboBox_AfterUpdate()
Me.FieldName = Me.YourComboBox.Column(1)

For example, I have a form that does the following:

Private Sub Combo64_AfterUpdate()
Me.LBS_GAL = Me.Combo64.Column(1)
Me.LBS_VOC = Me.Combo64.Column(2)

End Sub

After I enter the information into my Combo box (64), information is automatically entered into LBS_GAL and LBS_VOC.



hth...

 

[MLife]

thanks summer,and the other dude