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

values from a subform on a tabcontrol

1
Hello,
I have a form with a tabcontrol on it. On page_1 of that control is a subform with a (continous) form. How do I adress the fields in vba the fields on that subform. I tried everything, but it seems I always get en error. Please help me out!
TIA
Dirk
Oct 26 '13 #1
2 2387
jimatqsi
1,271 Expert 1GB
Here's the reference I always use: http://access.mvps.org/access/forms/frm0031.htm

Jim
Oct 26 '13 #2
ADezii
8,834 Expert 8TB
It can get a little hairy, but in the Northwind 2007 Sample Database, the Absolute Path to the [Quantity] 'Field' in the 'Sub-Form' sbfOrderDetails on the 'Page' Order Details_Page of the TabCtlOrderData 'Tab Control' in the [Order Details] 'Form' would be:
Expand|Select|Wrap|Line Numbers
  1. Forms![Order Details]!TabCtlOrderData.Pages("Order Details_Page").Controls("sbfOrderDetails").Form![Quantity]
Oct 27 '13 #3

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

Similar topics

1
by: Annette Massie | last post by:
I have a form (frmMainForm) that has a tab control (frmTab). This tab control has 4 pages. Each page has a subform on it. I am in the first tab's subform and in a listbox. I want to double click...
1
by: @ndy | last post by:
Hi developers, i've a problem with my tabcontrol. Before i open my form with a tabcontrol with 3 tabs (Frm_Files|Frm_Lines|Frm_Guarantee) all the controls on al the tabs must be enabled. With...
1
by: abprules | last post by:
I am trying to tab from my header to my detail section in a form that includes a tabcontrol form. It is not working. Can anybody suggest something. I have tried the following: Add a text box to...
3
by: Keith Wilby | last post by:
I have a form with 4 subforms on a tab control. How can I detect which sub/tab has the focus from the main form? Many thanks. Keith.
7
by: ApexData | last post by:
I am using the following code in my TabControl to manage subform loads. The code assigns the subForms SourceObject. - Do I also need code to DeAssign the SourceObject when leaving the Tab, I'm...
9
by: =?Utf-8?B?UGV0ZXJX?= | last post by:
I have a TabControl on a Windows form in which I have various tab pages each with a DataGridView, the first column of which is a DataGridViewCheckBoxColumn and subsequent columns being...
1
by: Jiwei06xie | last post by:
Hi, I have a main form with 3 subforms and some combo boxes. It is working fine as an independent form. However, when I draged into a tabcontrol page, two off the combo boxes stopped working...
7
by: poornesh K V | last post by:
This is the details: I have a Form : ProjectDetails This form is made up of a TabControl : maintabctrl1 (Say 10 pages) Each page has a subform : subForm1 This subForm1 has tabcontrol :...
3
by: accessbeginerry | last post by:
I have a form with subforms on it (subforms are designed on tabcontrol and each has separate page) After user enter information on form and tries to hit "Save" button i would like the access...
1
by: dkrzemien | last post by:
I've read and tried implementing, I believe, most of the simular topics/examples for my issue and I am still getting nowhere... I am trying to set a SubForm.RecordSource which is on a...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.