Linking Combo boxes

  • Thread starter Thread starter szczmj70
  • Start date Start date
S

szczmj70

I have 2 combo boxes that I need to link.

One is a list of contacts and the other is a list of Extensions. I have the
tables all worked out so that the AutoID number is synched in both fields.
How do I link these fields, so that when I select a contact, their extension
is automatically updated?
 
You just need to adjust the recordsource of the extension combo-box in the
after_update event of the contact combo-box.

But, is there a reason you're breaking it into 2 combo boxes instead of
putting it together in 1?
 
You just need to adjust the row source of the extension combo box in the
after_update event of the contact combo.

But why are you putting the extension in a combobox of it's own anyway?
Unless your plan is to allow users to search for contacts via their
extension.. you'd be better off putting the contact/extension in a single
combo and/or having the contact combo update a textbox.
 
Thanks. I was thinking too much. I did what you suggested and switched to
one combo field, because I would never search by extension. Thank you voice
of reason.
 
Back
Top