access forms recordsource

[abenitez77]

I have a form which has a tab control (10 tabs). I have a subform in each tab and each subform has a table or query associated with it. I want to open the form with no tables opening with them because the tables are big and take long to open. The tables are sql linked tables. This is an example of a tab. Is my syntax correct? When I open the main form, it does not show me the data, it shows the colums with "#Name?".

on the Open event of the form, I have this:
Forms![f_workspace].[SubFrmPBDExceptionsSummary].Form.RecordSource = ""

This is in the on click event of the tab:

Forms![f_workspace].[SubFrmPBDExceptionsSummary].Form.RecordSource = "SubQryPBDExceptionsSummary"
Forms![f_workspace].[SubFrmPBDExceptionsSummary].Form.Filter = "In Progress"
Forms![f_workspace].[SubFrmPBDExceptionsSummary].Form.OrderBy = "[SubQryPBDExceptionsSummary].[Inddue] Desc"
Forms![f_workspace].[SubFrmPBDExceptionsSummary].Form.OrderByOnLoad = "Yes"
Forms![f_workspace].[SubFrmPBDExceptionsSummary].Form.Refresh

 

[abenitez77]

nevermind...i think I will try this another way.