Hello,

Any help on this would be great. I have two combo's, one is an name
selector, the second one is a number selector, but I would like the
second one to automatically set itself to the number that corresponds
to the name selected in the first combo.

The table I'm working with has two fields:

Name Number
-----------
Joe 123
Jim 456


Combo1 is attached to the Name field. Combo2 is attached to the Number
field. When I select Jim in combo1, I want Combo2 to set itself to
456, etc...

This table also has a key ID field if that helps.

Any help is appreciated.

Thanks in advance,
--FB

Thank you very much. This gets me closer, however it does not work. I
have tried this in different variations: taking the outside quotes out
of the query string, as is, placing in the code module and in the
property table...and it is just not working.

Does my second combo need certain properties set in vertain ways?

Have you replaced control names with your own (Combo1, Combo2)?
Also, we are talking about adding a new record, right? Or changing an
existing record. We are not talking about a form used for searching
records, correct?

Good luck,
Pavel

FrankBooth wrote: