Listbox values don't change when record changes

[Repent34]

I created a form that has a listbox containing names of reps. The names I
put into a seperate table. Another table I have lists sales produced by the
names of reps from the first table. I have a relationship between the two
tables linked to "rep" in both tables. When I move through the records
using vcr controls, the rep field never changes, it always stays with the
first name in the listbox. I can click on the dropdown to see all the names
and they are there.

what am I doing wrong?

 

[fredg]

I created a form that has a listbox containing names of reps. The names I
put into a seperate table. Another table I have lists sales produced by the
names of reps from the first table. I have a relationship between the two
tables linked to "rep" in both tables. When I move through the records
using vcr controls, the rep field never changes, it always stays with the
first name in the listbox. I can click on the dropdown to see all the names
and they are there.

what am I doing wrong?

Sounds as though your List Box is NOT BOUND to a field in the table.
Check the List Box's Control Source.

 

[Repent34]

It is bound to the field called "rep" in the main table.

the first table has these fields:
ID--primary key
serial number
region
rep
city
state
zip


the second table is a list of all reps:
ID--primary key
rep

I was reading somewhere about foreign keys but cannot find any clear info on
it. Do I need that type of setup? I currently have a relationship between
the two tables linking the ID fields. I also tried linking the "rep" fields
to no avail. No matter what I've tried, obviously the wrong things, the rep
dropdown never changed as I go through the records.

I even created another table and linked my form to that table and manually
selected the rep I wanted and entered in some data. When I then move
through the records the rep just stays on whatever value I left it at, it
never changed to the value I had entered when I created the record.