Using combo box with forms.

[microsoftgirl]

I have a form for transaction details.
Within the transaction details form are some fields that have been taken from a query:

Supplier ID
Product ID
Order Date
Purchase Cost
Delivery Quantity
Total cost

I want to use a combo box, to automatically fill in the Supplier ID, Product ID and Purchase Cost. So that the user would not have to type these fields in, which would most likely lead to mistakes.

When using the combo box, I can only use it to fill in one of these three, because it only allows me to select one value to store, and one field to store that value in.

Does anyone know how I can select three values to store, and three fields to store them, and can you please explain as simply as possibly?

 

[RuralGuy]

Are the values you need in the RowSource of the ComboBox? If so then you can use the AfterUpdate event of the cbo to move those values to other controls on your form.
Me.OtherControl1 = Me.ComboBox.Column(1)
Me.OtherControl2 = Me.ComboBox.Column(2)
...using your control names of course.