Form not displaying correct results from combo box

[gmazza via AccessMonster.com]

Hi there,
I have a combo box that shows 2 key fields from my table.

On my form, if I navigate through the records, the 2 fields on my form show
different values, depending on whats in the table. However, if I choose from
the combo box, only the 1st field shows on the form and the 2nd field doesn't
change. How can I get around this?
Here is a sample:

Table Fields(both keys):
Criteria Country
1 USA
1 Canada

On the form when I choose 1 USA, it shows on my form. When I choose 1 Canada
from the combo, USA still remains in the Country field on the form.

I will mention that both the Criteria field and Country field on my form are
also combo boxes so when the user wants to create a new record they can
choose from any Criteria or Country.

Thanks!

 

[June7 via AccessMonster.com]

This is a duplicate thread.

Hi there,
I have a combo box that shows 2 key fields from my table.

On my form, if I navigate through the records, the 2 fields on my form show
different values, depending on whats in the table. However, if I choose from
the combo box, only the 1st field shows on the form and the 2nd field doesn't
change. How can I get around this?
Here is a sample:

Table Fields(both keys):
Criteria Country
1 USA
1 Canada

On the form when I choose 1 USA, it shows on my form. When I choose 1 Canada
from the combo, USA still remains in the Country field on the form.

I will mention that both the Criteria field and Country field on my form are
also combo boxes so when the user wants to create a new record they can
choose from any Criteria or Country.

Thanks!