By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,570 Members | 999 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,570 IT Pros & Developers. It's quick & easy.

Changing recordsource of subform

P: 12
Is there any way to change the recordsource of a subform from the mainform?

I have a subform that I would like to have return data from a table based on selections from multiple checkboxes on the main form. When these selections are made I want the recordsource of the subform to update according to this criteria

My main form is called EDIT_PARAMETERS and the subform is called SF_EDIT_PARAMETERS. I have tried a few different code snippets and have had zero luck.

This is an example of the type of recordsource that I would like to assign to the subform - RecordSource = "SELECT [ITEMNMBR], [LOCNCODE], [VALIDATE], [ORDERING_ALLOWED], [INV_REQUIRED], [MAX_QTY], [TIMEFRAME] FROM [BRANCH_ORDER_VALIDATION_PARAMETERS] ORDER BY [LOCNCODE], [ITEMNMBR]"

I don't want to use the filter because I am going to have multiple criteria and am not sure if I would be able to anyway.

Any help would be greatly appreciated.


Jul 3 '07 #1
Share this Question
Share on Google+
2 Replies

P: 12
Nevermind, I figured this one out on my own!
Jul 3 '07 #2

Expert Mod 15k+
P: 31,442
Thanks for letting us know Chuck.
I love good manners :)
Jul 3 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.