access 2010 vba code to open table without "click to add" field option

In Access 2010 if you set up relationship between tables it will automatically give you the + sign for related records.

I tried building a form that mimicked that functionality by creating a continuous subform and tried to place it on another continuous subform but you can't have a continuous subform on a continuous form.  I would love to get this to work if anyone knows how.

Or i could open the table for the user and allow them to use the build in functionality, but i don't want them to be able to "Click to Add" any fields, but can't find the vba code to do this.

Any help is greatly appreciated.
BFanguyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BFanguyAuthor Commented:
The plot thickens.  I move the tables to SQL and now I can't get the built in functionality for tables and their related records to work at all.
0
Gustav BrockCIOCommented:
No, this drill-down will only work for Access tables.

/gustav
0
Nick67Commented:
but you can't have a continuous subform on a continuous form.
That isn't entirely correct
I thought that too at one time
You cannot have a subform in the detail section of a continuous form
There are ways to put a subform in the form header/footer of a continuous form, though.

@Capricorn1 has worked out how to do that, so has @mx and others
http://www.experts-exchange.com/Database/MS_Access/Q_24072078.html
http://www.experts-exchange.com/Database/MS_Access/Q_28138749.html
http://www.experts-exchange.com/Database/MS_Access/Q_28579839.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

PatHartmanCommented:
I found an old app where I tried this technique.  It was A2003 so I'm not sure if it still works but I'm running it in A2013 and it seems to.  I can't say what would happen if the tables were SQL Server but I'm not sure why it would matter since we are dealing with a form.Design ViewDesign ViewForm view
Here it is in Design view and in Form view.  The two subforms are defined as having DS view.

I never actually used it because I decided it was confusing.  Instead I went with a popup as the lower level.
0
BFanguyAuthor Commented:
PatHartman I assume these tables are in access not SQL server correct?
0
PatHartmanCommented:
Correct. I don't know if it works with SQL Server.  As I said, I didn't like the final appearance.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

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.