Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Link Access Forms

Posted on 2014-09-13
2
Medium Priority
?
183 Views
Last Modified: 2014-09-13
I have a Continuous form (frm_Mapping) that  I would like to drill down to another Continuous form (frmAccounting_Transactions). The fields to link are both text fields (AE_ID). THANKS
0
Comment
Question by:shieldsco
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 40320937
you can open the form "frmAccounting_Transactions" with a where condition from form frmMapping

docmd.openform "frmAccounting_Transactions",,,"[AE_ID]='" & me.txtAE_ID & "'"
0
 

Author Closing Comment

by:shieldsco
ID: 40320959
Great--Thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying 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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

564 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