Unable to change a selection in a combo box -- Requery?

[Guest]

I am having what I think is a “requery†problem with some combo boxes. Here’s
the setup.

In the first combo box (cboState), the user selects a state. In the second
combo box (cboSourceName), a filtered list of contacts for that state with
their titles appears. After selecting the desired contact, two other controls
on the form are filled with the contact’s phone and e-mail address.
Everything works fine unless a user selects the wrong contact by mistake. The
cboSourceName will not allow a new selection from the list.

I have the following code in the After Update event of cboState:
Private Sub cboState_AfterUpdate()
cboSourceName.Requery
End Sub

I tried putting a requery in the On Change event of cboSourceName, but that
didn’t work (can a control requery itself?).
Here is the cboSourceName Row Source query.

SELECT qry_Contacts_Data_Entry.StateAbr, qry_Contacts_Data_Entry.FullName,
qry_Contacts_Data_Entry.ContactType, qry_Contacts_Data_Entry.Phone,
qry_Contacts_Data_Entry.Email, FROM qry_Contacts_Data_Entry WHERE
(((qry_Contacts_Data_Entry.StateAbr)=forms!frm_SR_Data_Entry.cboState));

Here is the Row Source value for the [phone and e-mail address controls:
=cboSourceName.Column(3)
=cboSourceName.Column(4)
I know these also need something in an event, as well.

Any help you can provide will be very much appreciated.

 

[Guest]

Folks. I'm replying to my own question so as not to waste anyone's time. In
some way, my "problem" has resolved itself on its own, and I am now able to
change the selection in the combo box.