List box will not change when with record "Watson via AccessMonster.com" <u7122[ at ]uwe> 07.09.2006 18:12:21 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1

Re: List box will not change when with record Marshall Barton <marshbarton[ at ]wowway.com> 07.09.2006 19:02:18 Watson via AccessMonster.com wrote: [Quoted Text] >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. To force the list box to sync to the current record, the form's Current event needs to Requery the list box. -- Marsh MVP [MS Access]