cmd.requery(specific query) requeries all queries on my form! please help!

[mejia.j88]

Hello programmers,

I have a form that uses 1 cbo box called cboWO based on a main query to populate text boxes and a list box. Call it Qry_WO.

i have another query filtered by the text boxes mentioned above. Call it Qry_Boat.
qry boat populates a cbo box called cboBoat, operators will choose the appropriate option.


in the event that an operator chooses the wrong option in cboWO, then chooses the correct one, I want qry_boat to requery to yield hte correct options for cboBoat.



in my vba code, when i type

docmd.requery (qryBoat) it refreshes the other queries on the form.

how can i avoid this from happening. it should only requery that specific query.

thank you,
Jorge


i can post the code if needed. i can also post the db using dropbox or a similar option.

[pbaldy]

Try

Me.cboBoat.Requery

[mejia.j88]

Pbaldy, this works great.
I tried it yesterday before I left work, it worked the first time but i didn't have time to test it.

Do you know why docmd.requery (queryname) requeries everything?

[pbaldy]

I would speculate that it's because you didn't properly specify the control, which would look like:

docmd.requery "qryBoat"

But I always use the syntax I posted, so I'm not sure.