G
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.
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.