Solved

Drill Down on Access Form

Posted on 2014-09-13
6
974 Views
Last Modified: 2014-09-21
I have a form (frm_Mapping) that  I would like to drill down to another form (frmAccounting_Transactions). The fields to link are both text fields (AE_ID). I have attached a copy of the DB (Access 2007)
ATM-V.1.1.accdb
0
Comment
Question by:shieldsco
  • 4
  • 2
6 Comments
 
LVL 39

Expert Comment

by:als315
ID: 40320703
Can you give more details about composition of frmAccounting_Transactions? Now it is continuous form, which can't have subforms. You can place it to form's footer. Where should be placed subform frm_Mapping?
0
 
LVL 39

Expert Comment

by:als315
ID: 40320706
Look at sample with subform in footer
ATM-V.1.1.accdb
0
 

Author Comment

by:shieldsco
ID: 40320849
I do not see subform in footer
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 40321091
Accounting transactions - main form, Mapping - subform
screenshot
0
 

Author Comment

by:shieldsco
ID: 40321866
That's not what I really want. I want to drill down to another continuous form
0
 
LVL 39

Expert Comment

by:als315
ID: 40322396
Can you show expected result?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now