By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,411 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Access 2003 Beginner - Requery from Combo Box Help

P: n/a
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

May 6 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

May 6 '06 #2

P: n/a
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?

May 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.