Need Form Help Please Combo box issues

[sparky01]

I need to be able to fill out a form with a combo box. I just need to know if it will work I have a table with these fields. [ticketnumber], [date], [Trucknumber][Job Location][client name], [time to pickup], [time to deliver],[offroadmiles],[client pay] [state]. What I would like to do is with a combobox which is [job locataion] populate [client name], [state], [time to pickup], [time to deliver], and [client pay]. I need all of this information to store in a table that I will use to query from. Can I do this??????

David

 

[slvrracr]

If you create your combobox with multiple columns you can get info from each column. In your combobox, create a row source to include these columns; job location, client name, state, time to pickup, time to deliver, and client pay.
In your beforeUpdate event of the combobox, fill your form fields with the appropriate data.

me.clientname = me.combobox.column(1)
me.state = me.combobox.column(2)
...
You can do this for any or all columns in the combobox. Remember that the first column is number (0).

Hope this helps