drop down list fill in a form

[aman909]

I have two tables, one called customers and the other called products. I would like to create a form called orders.

On here what i would like to do, is a drop down list for the customer ID. When the customer ID is selected the rest of the fields get filled in with the correct details. So their firstname, lastname, address etc get put into the fields.

Same for products as well.

How do i do this?

[hjozinovic]

hi there!

You should make a query that contains all the info you want to be filled in automatically i.e. (CustomerID, Fname, Lname...)
Open combobox's property list:
-Set Bound column property to: 1
-set Column count property to: 3 (or the number of fields in your query)
-set Column widths to: 5;0;0 (only first column will be displayed-5cm, and the other two will not be displayed, but they will be present though)

In combobox's after update event property write code like this:

Me!Fname=Me!CustomerID.Column(1)
Me!Lname=Me!CustomerID.Column(2)

note that 1st column has index 0, 2nd has index 1 (Fname)...

For more info you can search the Column property in Microsoft Visial basic help!

Best, H.