List box will not change when with record

  • Thread starter Thread starter Watson via AccessMonster.com
  • Start date Start date
W

Watson via AccessMonster.com

I have a list box on my main form. The values in the list box have an id
that links to the main form id. But when i click on the next records from
the main form, the list box does not change to show the lists that are for
that id.

the list table has the id and the main form table have the id. what am i
doing wrong.

I tried to change the query of the list table to : Forms!frmMain!codeID but
the list still doesn't change when I go to the next record on the main form.

please help.

Watson
 
Watson said:
I have a list box on my main form. The values in the list box have an id
that links to the main form id. But when i click on the next records from
the main form, the list box does not change to show the lists that are for
that id.

the list table has the id and the main form table have the id. what am i
doing wrong.

I tried to change the query of the list table to : Forms!frmMain!codeID but
the list still doesn't change when I go to the next record on the main form.
Click to expand...


To force the list box to sync to the current record, the
form's Current event needs to Requery the list box.
 
Back
Top