How to change the RowSource in a SubForm

Simon

Dear reader,

The syntax for the VBA code to change the RowSource of a Form is:
Forms!FormName. .RowSource = "TableOrQueryNa me"

But now the syntax to change the RowSource of a SubForm:
Forms!MasterFor mName..!SubForm Name...RowSourc e =
"TableOrQueryNa me"

Is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon

Aug 19 '07 #1

Subscribe Reply

3545

Steve

Hi Simon,

Neither a form nor a subform has a rowsource property. They both have a
recordsource property. Comboboxes and listboxes have a rowsource property.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdata sheet.com

"Simon" <Sv********@Ver satel.nlwrote in message
news:46******** **************@ news.tele2.nl.. .

Dear reader,

The syntax for the VBA code to change the RowSource of a Form is:
Forms!FormName. .RowSource = "TableOrQueryNa me"

But now the syntax to change the RowSource of a SubForm:
Forms!MasterFor mName..!SubForm Name...RowSourc e =
"TableOrQueryNa me"

Is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon

Aug 20 '07 #2

StopThisAdvertising

"Steve" <so***@private. emailaddresssch reef in bericht news:13******** *****@corp.supe rnews.com...

Hi Simon,

Neither a form nor a subform has a rowsource property. They both have a
recordsource property. Comboboxes and listboxes have a rowsource property.

PC Datasheet

Steve has a 'advertising' property.
Also he has a 'we-don't-like-him-here' property.

--
This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html
Until now 3500+ pageloads, 2300+ first-time visitors (these figures are rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==Simply killfile 'StopThisAdvert ising'.
Newbees will still see this warning-message.

ArnoR

Aug 20 '07 #3

Similar topics

3537

Speed tip: Set RowSource of Subform's Combo box in GotFocus event rather than Enter

by: Krisa | last post by:

Hello all, I just discovered something (stop me if you've heard this before....) that was causing me a significant performance hit when opening a form with subforms. To speed up loading the form, I set the rowsources of its, and its subforms', combo boxes in the "Enter" events of the combo boxes. That's the standard trick for not loading the rowsource unless/until the user actually needs the combo box. For example:

Microsoft Access / VBA

9372

Limiting combo box rowsource and displaying them in continuous form

by: B | last post by:

I know there are several ways to speed up combo boxes and form loading. Most of the solutions leave rowsource of the combo box blank and set the rowsource to a saved query or an SQL with a where clause after users typed in one or several letters/digits. My problem is as follows Most of the time I need to display form in continuous format, that means the combo box will appear in each record. For example I have a form to let users view...

Microsoft Access / VBA

2612

Change query from textbox on form

by: DebbieG | last post by:

I have a form based on this query: SELECT Students.LastSerDT, OtherInfo.Served, OtherInfo.HSGradYr, OtherInfo.ActivePart, OtherInfo.Served, Students.SSN, & ", " & & " " & AS Name, Students.LastNM, Students.FirstNM, Students.MI, Students.DOB, Students.GenderCD, Students.EthnicityCD, Students.EligibilityCD, Students.UBInitiative, Students.NCESSchID, Students.ProjEntryDT, Students.ProjReEntDT, Students.LastSerDT, Students.Reason,...

Microsoft Access / VBA

26203

Update a Listbox after making a change in a field

by: N. Graves | last post by:

Hello... thank you for your time. I have a form that has a List box of equipotent records and a sub form that will show the data of the equipment select from the list box. Is it possible to make a change in the name field in the details, then refresh the list box with new name? Please help and thanks!

Microsoft Access / VBA

3448

Criteria For Subform Combobox Rowsource

by: Tom | last post by:

I have the following tables: TblState StateID State TblCounty CountyID StateID County

Microsoft Access / VBA

3216

Dynamic SubForm Rowsource

by: ruthboaz | last post by:

Hi, I need to set the rowsource dynamically by passing a query to a subform, when a button in the main form is clicked. Pls assist. Thanks & Regards, Ruth.

Microsoft Access / VBA

23821

How to change the RowSource in a SubForm in VBA code

by: Simon | last post by:

Dear reader, The syntax for the VBA code to change the RowSource of a Form is: Forms!FormName..RowSource = "TableOrQueryName"

Microsoft Access / VBA

7460

How to change the RowSource in a SubReport

by: Simon | last post by:

Dear reader, The syntax for the VBA code to change the RowSource of a Master Report is: Me.RowSource = "TableOrQueryName"

Microsoft Access / VBA

8516

Passing parameter to rowsource of combo box dynamically

by: jaynea | last post by:

Hi I have a main form which contains questions and a subform within it which contains elements which relate to the main form. they are linked by a field called question_ref so if I page through the records on the main form the elements that are relevant to that question display in the subform. Within the subform I have a combo box which calls a table which contains the following question_ref and a text field. I would like to be able to...

Microsoft Access / VBA

9647

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10356

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10100

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7509

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6744

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5396

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5528

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4061

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2893

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General