Solved

How to access datasheet subform on a tab control

Posted on 2013-07-01
18
1,486 Views
Last Modified: 2013-07-02
Hello experts

Im strugling with accessing a subform via VBA which is placed on another form on a tab control.
So the form Im looking for is called: 'TreeLevels subform'. It is placed on form: FormTagValidation which is on tab control's  ("TabCtl0") page - 'Validation'.
Tab control is on form 'FirstStage'.

So to e.g. set focus on FormTagValidation or to set focus on page validation I need to use code:
Forms!FirstStage!FormTagValidation.SetFocus

Forms!FirstStage.TabCtl0.Pages.Item("Validation").SetFocus

Open in new window


Well I cant make it working for 'TreeLevels subform'

My ultimate goal is to apply query to this subform's RecordSource.

cheers
0
Comment
Question by:yahooooo
  • 8
  • 8
  • 2
18 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39291233
try this


Forms!FirstStage!FormTagValidation.Form![TreeLevels subform].Form.RecordSource= "query name"


see this links for reference
http://access.mvps.org/access/forms/frm0031.htm


http://access.mvps.org/access/forms/frm0025.htm
0
 
LVL 3

Author Comment

by:yahooooo
ID: 39291263
So I thought but I got this error


error
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39291321
check the "NAME" of the subform Control  (the control that housed the subform)
and use it in the expression instead of using the name of the subform
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39291326
Can you provide a screenshot of the forms in question?  It sounds like you might actually have a main form, subform, nested subform configuration.
0
 
LVL 3

Author Comment

by:yahooooo
ID: 39291354
@capricorn
thats FormTagValidation which hosts subform and no it doesnt work

@Fyed
screen
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39291368
<thats FormTagValidation which hosts subform and no it doesnt work>

i dd not mentioned the name of the form that housed the subform,

i said, the control in form "FormTagValidation" that housed the subform
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39291401
Where are you attempting to do this from?  Is there a control on the main form, or an even on the main form?

You should be able to use:

Forms!FirstStage!FormTagValidation.Form.Recordsource = queryName

or

Form_FirstStage.FormTagValidation.Form.Recordsource = queryName
0
 
LVL 3

Author Comment

by:yahooooo
ID: 39291547
@capricorn
i tried both:
    Forms!FirstStage!TabCtl0!FormTagValidation![TreeLevels subform].SetFocus
    Forms!FirstStage!TabCtl0![TreeLevels subform].SetFocus
error 451
@Fyed
Im trying to do that from another tab's form. It works find if Im on this form through me.[treelevels subform]...
There is a tab control on the main form
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39291605
yahooooo,

did you look at the second link i posted above?
there is no need to reference the Tab Control to refer to the subform.
0
 
LVL 3

Author Comment

by:yahooooo
ID: 39291618
Yes i know that. Got confused with that control u asked for. Thought you meant that tab control. It's late, deadline in few hours and im sick so good excuse I guess ;)

I created this subform by drag and drop a table on FormTagValidation. Not sure if there is any control over there.
I guess I could move all my controls and this subform straight to the tab control (so remove FormTagValidation) and that should work, but that would be a lot of work...
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39291868
upload a copy of your db..
0
 
LVL 3

Author Comment

by:yahooooo
ID: 39292987
Hope that helps. I replaced original data with few dummy rows and removed forms which weren't relevant
Maint-Build-Tool-v0.04---test2.accdb
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39293178
yahooo,

from where are you trying to access the subform "TreeLevels subform"?



see this rev.
Maint-Build-Tool-v0.04-rev.accdb
0
 
LVL 3

Author Comment

by:yahooooo
ID: 39293610
Looks like I deleted too many things ;)

I created a button on 'treeview' tab. What I need is perform any operation on TreeLevels subform from treeview. that could be for example: to set focus on TreeLevels subform or to update TreeLevels subform's recordset basing on some query. See commented code in an onclick event
thanks
Maint-Build-Tool.accdb
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39293695
did you look at the rev i uploaded? comment on that first .
0
 
LVL 3

Author Comment

by:yahooooo
ID: 39293833
ok I addapted it to my solution :) works great

so what I was looking for is:
Forms!FirstStage!FormTagValidation.Form![TreeLevels subform].Form.RecordSource = "WrongParent"

Open in new window

and what I missed was " .Form " after FormTagValidation
thanks
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39293854
see my first post at http:#a39291233
0
 
LVL 3

Author Comment

by:yahooooo
ID: 39293953
silly me. I havent noticed that bit :/ sorry for wasting your time bud
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question