Changing RecordSource (Query) Of the Form Inside a SubForm

[RichardAnderson]

Hello Guys....

OK, here is the deal,



I have a main form called frmMainProgram. It has 2 subforms called SubMain and SubDetails. The record source for SubMain is frmProduction_Schedule_Builds which has a record source of qryProduction_Schedule_Active. This query shows all active builds for the production line. On the main form frmMainProgram, I have a series of buttons that I want to change the record source (query) for frmProduction_Schedule_Builds that is INSIDE the subform SubMain. Another query is qryProduction_Schedule_Today or qryProduction_Schedule_BySalesOrder.

Any help or tips would be great!

[June7]

So you want to change the subform to sort by different fields. Could use code that sets the Sort By property.

Since the buttons and code are on main form, the code has to reference the subform properties through the subform container control. Would be easier to make the subform Continuous view and put the buttons in its form header section.