Access Requery of underlying Form

[tcheck]

This seems pretty simple but I would like to select a combo box and after the user selects the combo box (Which Is a City) I want to use the underlining query of the form to run because I am using the <>False Criteria for a command of;

IIf([Forms]![frm_Deals]![CheckCity]=True,[City] Is Not Null Or [City] Is Null,[City]=[Forms]![frm_Deals]![SelectCity].[Value])

I may have other combo boxs with other information so that is why I want to run the underlying query. I have used the After Update command of;



Me.RecordsetClone.FindFirst "[XXXX] = '" & Me!FindXXXX & "'"

But I want to requery the query under the form. Hope this makes sense.

[hertfordkc]

This seems pretty simple but I would like to select a combo box and after the user selects the combo box (Which Is a City) I want to use the underlining query of the form to run because I am using the <>False Criteria for a command of;

IIf([Forms]![frm_Deals]![CheckCity]=True,[City] Is Not Null Or [City] Is Null,[City]=[Forms]![frm_Deals]![SelectCity].[Value])
Is this giving you the value you expected? Without context, I'm mystified by it.
I may have other combo boxs with other information so that is why I want to run the underlying query. I have used the After Update command of;

Me.RecordsetClone.FindFirst "[XXXX] = '" & Me!FindXXXX & "'"
Might not onClick--- Me.Requery work?
But I want to requery the query under the form. Hope this makes sense.

-------------------------------------------------------------------------------------
Hope this helps.