If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing the RecordSource on a Form programmatically
How I can change the Record Source programmatically on a predetermine Form?
EggHeadCafe - Software Developer Portal of Choice ASP.NET TraceListener for Debugging http://www.eggheadcafe.com/tutorials...tener-for.aspx |
#2
|
|||
|
|||
Changing the RecordSource on a Form programmatically
The form must be open, and you use something like:
Forms("NameOfForm").RecordSource = "NameOfQuery" or Forms("NameOfForm").RecordSource = "SQLStatement" -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) Juan F Mena wrote in message ... How I can change the Record Source programmatically on a predetermine Form? EggHeadCafe - Software Developer Portal of Choice ASP.NET TraceListener for Debugging http://www.eggheadcafe.com/tutorials...tener-for.aspx |
#3
|
|||
|
|||
Record Source programmatically.
Thanks!!! Is there any way to update the record source from another form?
Douglas J. Steele wrote: Changing the RecordSource on a Form programmatically 03-Oct-09 The form must be open, and you use something like: Forms("NameOfForm").RecordSource = "NameOfQuery" or Forms("NameOfForm").RecordSource = "SQLStatement" -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) Juan F Mena wrote in message ... EggHeadCafe - Software Developer Portal of Choice JavaScript Bar Graph Control http://www.eggheadcafe.com/tutorials...raph-cont.aspx |
#4
|
|||
|
|||
Record Source programmatically.
Sure. You can run that code from anywhere. The only caveat is that the form
whose RecordSource you're trying to change has to be open. That means you may need to open the form first, either in Normal view or in Design view. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) Juan F Mena wrote in message ... Thanks!!! Is there any way to update the record source from another form? Douglas J. Steele wrote: Changing the RecordSource on a Form programmatically 03-Oct-09 The form must be open, and you use something like: Forms("NameOfForm").RecordSource = "NameOfQuery" or Forms("NameOfForm").RecordSource = "SQLStatement" -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) Juan F Mena wrote in message ... EggHeadCafe - Software Developer Portal of Choice JavaScript Bar Graph Control http://www.eggheadcafe.com/tutorials...raph-cont.aspx |
Thread Tools | |
Display Modes | |
|
|