drop downs not updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database based on surveys with 3 tables: account, contact, and
survey. The account and contact tables are linked by the acccount id, the
survey and account tables are also linked by account id. I have a data entry
form where the surveys can be added by selecting the account from a drop down
and then the contact from a drop down (only showing the contacts from that
account). However after you select the contact from the drop down and you
selected the incorrect account and change it - when you go to the contact
drop down - it still lists the contacts from the first account. How can you
get it to change to the currently selected account?
 
Patricia,

This doesn't happen automatically; code must change the RowSource of the
Contacts combo box. Normally this would be done by the AfterUpdate event
procedure of the first combo box, so I'm not sure why it wouldn't do it after
changing the account. Please post the code module for the form and I'll see
if I can help.

Sprinks
 
Back
Top