Question about 1 form multiple querys

[kc5747]

I need to create one main form and have the user click command buttons to run diffrent queries on the same form (1 at a time).

 

[Autoeng]

OK. What's your question? And why did you post this under Modules and VBA when this should have been under Forms or at least queries>

Autoeng

 

[AngelT]

Why hasn't there been anyone challenged enough to answer this question?
I too am in need of assistance with this same matter.
Only I am dealing with multiple subforms.

I have a hiearchy of:
"Main Form"
"Mainsubform" (unbound); which in this case displays an
"Orders" form
"Orders" has a subform displaying "Order Details"

Forms![MAIN FORM].Form!MainSub.SourceObject = "Orders"
updates the subform appropriately; however I need to take a field value - selected by the user - in "Order Details" and requery or filter the "Orders" form. [hoping that made sense???]

Basically the user receives a list of outstanding orders, and I provide a command button to give the user opportunity to view the single order selected in detail.

All activity is being displayed (refreshed) in the Mainsubform.