473,324 Members | 2,541 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Changing recordsource of subform

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.

Thanks,

Chuck
Jul 3 '07 #1
2 1739
cek172
12
Nevermind, I figured this one out on my own!
Jul 3 '07 #2
NeoPa
32,556 Expert Mod 16PB
Thanks for letting us know Chuck.
I love good manners :)
Jul 3 '07 #3

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

Similar topics

7
by: Nicolae Fieraru | last post by:
Hi All, I am trying to change the rowsource of a combobox when I click on it. I played with many events, associated with the form and the combobox, but still haven't figured out what is the way...
2
by: Bill Agee | last post by:
I have a subform called PaymentDetails and would like to dynamically assign the recordsource after the form/subform is opened. The recordsource for Payment Details is "PaymentDetails_qry" which...
9
by: robert d via AccessMonster.com | last post by:
I'm not sure why the following isn't working. The subform loads correctly, but no data is displayed. I'm certain that there is data and I have checked that the SQL statement does in fact return...
2
by: Bill R via AccessMonster.com | last post by:
I'm trying to use the same subforms for two different mainforms. The first main form is "frmSwaps" and the second main form is named "frmSwapsLive". The recordsources for the subforms have...
3
by: john | last post by:
I have a form with Members and in that form a subform with Transactions. Those are linked (on banknr) 1xM which I've set in the database relations. Now I would like to copy the form and modify it....
8
by: NJonge01 | last post by:
Great thanks to all the helpful responses I've read! Recently using MS Access after a lengthy (7-10 years) away from the tool. I apologize for posting a question that for all intents & purposes...
1
by: questionit | last post by:
If i open a form with filter like this: Call DoCmd.OpenForm("frm_myForm"", acNormal, " = " & Me.RefID) Now there is a subform in frm_myForm. How would i change the RecordSource of that...
8
Megalog
by: Megalog | last post by:
Hey guys.. my turn to ask a question: I'm having a weird issue with a form I've reworked. This form has a combo box, which when used is changing the recordsource of a subform. This subform has...
19
by: postman | last post by:
I have a parent form bound to a recordsource and several controls are bound to fields in that recordsource. There are also several unbound controls that are used to display various data in a...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.