Trying to related a combo box info to a table.

[tinmar]

I'm trying to work out the following.

- Have a table with
- Name
- contract expiry date

I have then in a form added the above, what I want to also do is to add 2 combo boxes which are related e.g first box says " customer wants to update contract ( Yes or NO ), then if 'yes' the 2nd box shows new rate plans...... What I want to know is how do I put this second bit into a form, since the combo stuff is not initially in the table. I hope this makes a bit of sense what im trying to do. The table info is also just imported on a daily basis

 

[kjv1611]

So.. what you mean is that the current contract rate plan is not in the table, b/c it would be a new contract update, since the customer is just now renewing or opening new contract?

So, if that is correct...

You need a list of values, or else a table as the record source for your combo boxes. THAT table would be totally separate (for the new rate plans) from anything else. You use that for your Record Source. The Control Source would be set to the field you're wanting to update.

--

"If to err is human, then I must be some kind of human!" -Me