?
Solved

Drill Down on Access Form

Posted on 2014-09-13
6
Medium Priority
?
1,379 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 41

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 41

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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 41

Accepted Solution

by:
als315 earned 1000 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 41

Expert Comment

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

599 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