adding values box from one combo to another (1 Viewer)

[misslee1888]

Hi

I wonder if what I am looking to do is possible.
I want to have a record in which I can choose a value from a combo box and have that value added to another combo box on the same form.

The value of this second combo box should change according to what was added to that record.

I have searched the forum and I am not sure if this is possible.

The purpose of the second combo box is to be used in a cascading combo box senario on another form. If this is not possible then please let me know.

If it is then I would appreciate it if you could point me in the right direction. Thanks

 

[Jimused]

I did this once by having the second combo box base on a query who's criteria was linked to what was chosen in the first combo box. In my case, the second combo box simply displayed data that was linked to the item chosen in the first. For example, a caller calls, you choose him in the first combo, if there are any children associated with this caller they populate the second combo box.
Does this sound like what you are looking for?