Requery Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ripper - 17 Oct 2005 16:01 GMT

I use the following rowsource code to filter one list box by another.

SELECT tblStudents.StudentNumber, tblStudents.Name, tblStudents.Group FROM
tblStudents WHERE tblStudents.Group=forms!frmGrades!lstGroupName;

No problem, except it doesn't work except when the form is opened. What is
the command to make the second listbox update itself every time I click the
first listbox.

Signature

Thanks As Always
Rip

Reply to this Message

Klatuu - 17 Oct 2005 16:10 GMT

In the After Update event of the first list box:

Me.Listbox2.requery

> I use the following rowsource code to filter one list box by another.
>
[quoted text clipped - 4 lines]
> the command to make the second listbox update itself every time I click the
> first listbox.

Reply to this Message