whenever i do a combo list that refers to a table ie: Clients it fills the
same client into each new job that i create and i can't get it to set
different ones to each job. How do i fix this?
By setting up the combo box correctly. Since I have no idea how your
tables are structured, nor what you have done with the combo boxes, I
can't be all that specific!
Generally you would have a Form based on the Job table; in the Job
table there would be a ClientID field. On the Form you would have a
Combo Box with a row source like
SELECT ClientID, ClientName FROM Clients ORDER BY ClientName;
This combo box would be bound to the ClientID field; you'ld select
whichever client you want, and it will be stored in that field in the
table.
You may want to open the Northwind sample database and look at how its
Orders form handles subforms and combo boxes.
John W. Vinson[MVP]
