Access 2003 Beginner - Requery from Combo Box Help

[jay]

Hi.

I have created an unbound combo box in a form whose purpose is to pass
parameters to a query and then requery the requery.

The unbound combo box is named "ClosedFilter" The two parameters it
will pass to the query called "qry_WkReq" is "Yes" and "No." (The
field being requeried is a Yes/No type field.) After this, I created
an event procedure after update and coded:

ClosedFilter.Requery

This didn't work and this code is probably wrong. I found many
different examples searching through Google Groups and nothing seemed
to work out and query the records they way they need to be. I've used
Access for a while, but I'm just getting into coding modules and stuff
of that nature. Any help would be appreciated. Let me know of any
additional info needed.

Thanks!
Jay

[nate.vu]

Calling the Requery() method on the combo box will refresh the data
inside the combo box only. Is this what you want or do you want to
refresh the values of another field?

If you want to refresh the values in the combo box and it's not
working, check that the combo box has a row source defined for it &
also you might check the query.

If you want to refresh the values of another field you can call
Requery() on that field or on the entire form (better to only call it
on the field you want, though).

Hope that helps a little, but please tell me if I've
misunderstood/missed the point completely.

[jay]

Sorry for the extremely late reply. Unexpected leave. I would like to
refresh the all the data on the form after making a selection in that
combo box. Are there any examples of code I can look at?