Listbox requery

[Guest]

I have a listbox (lbProjects) that should enumerate all the Projects assigned
to a given Capital Request. The form (frmCER) is bound to the Capital Request
(tblCER) table, and its Primary Key is "CERID". The Project table
(tblProjects) has a foreign key in it called "CERID". I set up the listbox
initially unbound, with a record source that looked for all projects with a
CERID that matched forms!frmCER.CERID. It selected the first one just fine,
but as I scroll through the CERs, the listbox does not update. I coded the
OnChange event from the CERID field on the main form to requery the list box,
but no joy. I'm obviously missing something. Any ideas?

 

[BruceM]

If I'm following you correctly, the form's Current event may be where you
need to requery the combo box. By the way, it would help in such cases if
you post the row source SQL, or enough of it so we can get the idea.