Path to Subform Control

[sladetroityer]

I am trying to use the browse to action and I keep getting an error with my path? Can anyone help me?

 

[wiklendt]

what are you browsing? usually, "browse" indicates that you want to open a "browse for file or folder" dialog. yet your topic is for a path TO a subform control.

Depending on what you want, these might help:

Browse for folder/file API: http://www.access-programmers.co.uk/forums/showpost.php?p=786349&postcount=2

Subform syntax: http://www.access-programmers.co.uk/forums/showthread.php?t=102826

 

[sladetroityer]

I have a Report Center form and I want the reports to show up on that form as you pick the report from the cmd button on the side. The reports show up on the form and from there you can open them up in a separate window or just view the report right on the form. I copied the design from an Microsoft Sample database but the design view is locked out.

 

[sladetroityer]

frmNavagationMain.NavagationControl10>frmReportCenter.NavagationControl10

Can anyone help with my path on the subform control? The above argument isn't working.

 

[vbaInet]

Reference from where to where? From what control to what control?

 

[sladetroityer]

frmNavagationMain.NavagationSubform10>frmReportCenter.sfrReportPage

I'm not sure how to answer your question? But this is the latest argument that I treid and it doesn't work either

 

[vbaInet]

How can I understand what you're trying to do by looking at what doesn't work? Tell me what you are trying to do.

 

[sladetroityer]

Sorry..... It's hard to do this without pictures. However, I figured it out with trial and error.....and it actually works...

frmNavagationMain.NavigationSubform>frmReportCenter.sfrReportPage

Now I need to know how to filter or query employees with a button that filters by department number. I want retrieve records that belong to certain departments from the master employee table.

Any ideas on how I achieve that?

 

[vbaInet]

How are you going to input the department number?

When you say it works, what does the chevron (>) in your code do? Is this Access 2010?

 

[wiklendt]

I have a Report Center form and I want the reports to show up on that form as you pick the report from the cmd button on the side. The reports show up on the form and from there you can open them up in a separate window or just view the report right on the form. I copied the design from an Microsoft Sample database but the design view is locked out.

ok, so you have some reports already which are showing in the form already - so can you redefine your problem? are you getting error codes etc? what IS happening?

I can't imagine an MS sample database being "locked-out" - have you tried the SHIFT trick (hold down the SHIFT key while the database opens)? Alternatively, can you give a link to the MS sample AND the code YOU are currently using?

 

[sladetroityer]

This part is fixed. I finally figured it out.

THANKS

 

[sladetroityer]

I was able to fix the subform control. Thanks...

 

[vbaInet]

Oki doki!

 

[sladetroityer]

I have another issue, can you help?

 

[vbaInet]

Is it related to the subject of this thread? If it isn't post a new thread and send me the url.

 

[sladetroityer]

http://www.access-programmers.co.uk/forums/showthread.php?p=1117399#post1117399


Here is the url