473,322 Members | 1,523 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,322 software developers and data experts.

referencing controls in a tab subform

I have a form [formA] with a tab control [tab14] with a child [child83] with a subform [subformB] with a button [cmdDoit]. I want to click the button when I enter formA. I can't seem to get the correct reference.
I've tried
'Forms![formA].[Form]![subformB].[Form]![cmdDoit]
Me.[child83].[form]![subformB].[Form]![cmdDoit]
but it keeps treating subformB as a field.
Jun 29 '07 #1
5 1789
puppydogbuddy
1,923 Expert 1GB
I have a form [formA] with a tab control [tab14] with a child [child83] with a subform [subformB] with a button [cmdDoit]. I want to click the button when I enter formA. I can't seem to get the correct reference.
I've tried
'Forms![formA].[Form]![subformB].[Form]![cmdDoit]
Me.[child83].[form]![subformB].[Form]![cmdDoit]
but it keeps treating subformB as a field.
try it this way:
Forms![formA]![subformB].[Form]![cmdDoit]
Jun 29 '07 #2
try it this way:
Forms![formA]![subformB].[Form]![cmdDoit]
It gives me the error.
Run-time error '2465':

Microsoft Office Access can't find the field 'subformB' referred to in your expression.
Jun 29 '07 #3
puppydogbuddy
1,923 Expert 1GB
It gives me the error.
Run-time error '2465':

Microsoft Office Access can't find the field 'subformB' referred to in your expression.
verify that 'subformB' is the name of the subform control on the main form and not the name of the form object inside the subform control. Thanks.
Jun 29 '07 #4
verify that 'subformB' is the name of the subform control on the main form and not the name of the form object inside the subform control. Thanks.
Thanks, I didn't realize I needed to rename child83 to subformB.
Jun 29 '07 #5
puppydogbuddy
1,923 Expert 1GB
Thanks, I didn't realize I needed to rename child83 to subformB.

You are welcome. I am glad the problem is resolved.
Jun 29 '07 #6

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

Similar topics

5
by: Tony Williams | last post by:
I have a form on which there is a tabcontrol and on this onr of the tabpages is a tick box which opens Outlook with data from the main form and prompts the user to amend the message before being...
2
by: William Wisnieski | last post by:
Hello Everyone, Access 2000 I have a main form with a continuous subform. On the main form I have a text box that references a field on the subform. What I'd like it to do is show the value...
3
by: Shannan Casteel via AccessMonster.com | last post by:
I have a subform for listing parts. It has fields including: ClaimID, ITEM, NET PRICE, LIST PRICE, Quantity, Supplier, and a calculated field called Part Total. The subform is based on a...
3
by: 2obvious | last post by:
I have a DataGrid containing a TextBox control and a CustomValidator in each row. The CustomValidator fires a function that compares all TextBoxes for equality. The algorithm for comparison is...
1
by: Felipe Garcia | last post by:
Does makes difference referencing controls inside EVERY page <%@ Register TagPrefix="PC" Namespace="MyControls" Assembly="Personal.MyControls" %> or referencing controls ONCE inside web.config,...
2
by: Axel | last post by:
Hi, a question about something that seems very simple at first glance: is it possible to reference other controls of a subform in a query window without referencing through the parent form? I...
1
by: jundavid | last post by:
Hello there! Im just learning MS ACCESS because there is a system I need to modify. Im having a hard time referencing controls in another loaded forms. Can anyone help me? THANKS!
7
by: jundavid | last post by:
have a form and a subform. In the subform, I have a combo box which I would like to only show the records based on the control on the main form. Let say I have a record of employees which I would...
50
by: Proaccesspro | last post by:
Hello, Trying to nail down the correct syntax to reference a subform. Here is what I have, but it's not working: Forms!!!.SetFocus
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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.