How to have query execute when a dependent field is updated

[sandpking]

I have the query below (as a row source)update a list box with all the
employees of a supervisor. The problem is it doesn't automatically
update when a the referened field on the form (supervisor) is
updated. It works only when I choose a value, close the form and re-
enter the form.

Thanks in advance.

SELECT DISTINCT [Personnel]![LName] & ", " & [Personnel]![FName] AS
Expr1, [Personnel]![Supervisor LName] & ", " & [Personnel]![Supervisor
FName] AS Expr2 FROM Personnel WHERE ((([Personnel]![Supervisor LName]
& ", " & [Personnel]![Supervisor FName])=[Forms]!
[frmRequired_Single_Training]![Supervisor_Dropdown]));

[Gary Floam]

On the After_Update event of the Supervisor field, Requery the list box having
the query as its Rowsource.

Good luck.

<sa*******@yahoo.comwrote in message
news:11**********************@z28g2000prd.googlegr oups.com...

>I have the query below (as a row source)update a list box with all the
employees of a supervisor. The problem is it doesn't automatically
update when a the referened field on the form (supervisor) is
updated. It works only when I choose a value, close the form and re-
enter the form.

Thanks in advance.

SELECT DISTINCT [Personnel]![LName] & ", " & [Personnel]![FName] AS
Expr1, [Personnel]![Supervisor LName] & ", " & [Personnel]![Supervisor
FName] AS Expr2 FROM Personnel WHERE ((([Personnel]![Supervisor LName]
& ", " & [Personnel]![Supervisor FName])=[Forms]!
[frmRequired_Single_Training]![Supervisor_Dropdown]));

[sandpking]

The command below worked. Being a complete vb novice I wasn't sure
how the requery command should be set up.

This didn't work: Me.EmployeList.Requery

This did work: Me.Refresh( in the form fields After Update event...)
by Bjarne
On Jun 14, 1:57 pm, "Gary Floam" <[e-mail]:

On the After_Update event of the Supervisor field, Requery the list box having
the query as its Rowsource.

Good luck.

<[e-mail] in message

news:11**********************@z28g2000prd.googlegr oups.com...

I have the query below (as a row source)update a list box with all the
employees of a supervisor. The problem is it doesn't automatically
update when a the referened field on the form (supervisor) is
updated. It works only when I choose a value, close the form and re-
enter the form.

Thanks in advance.

SELECT DISTINCT [Personnel]![LName] & ", " & [Personnel]![FName] AS
Expr1, [Personnel]![Supervisor LName] & ", " & [Personnel]![Supervisor
FName] AS Expr2 FROM Personnel WHERE ((([Personnel]![Supervisor LName]
& ", " & [Personnel]![Supervisor FName])=[Forms]!
[frmRequired_Single_Training]![Supervisor_Dropdown]));- Hide quoted text -

- Show quoted text -

This