Solved

Drill Down on Access Form

Posted on 2014-09-13
6
937 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

760 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

22 Experts available now in Live!

Get 1:1 Help Now