Improve company productivity with a Business Account.Sign Up

x
?
Solved

How to access datasheet subform on a tab control

Posted on 2013-07-01
18
Medium Priority
?
1,766 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
LVL 50

Expert Comment

by:Dale Fye
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 50

Expert Comment

by:Dale Fye
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 2000 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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
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 …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

579 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