Solved

Openform subform filter from another form

Posted on 2011-03-07
4
419 Views
Last Modified: 2012-05-11
I have a doubleclick event on a PO Number field.  When it is doubleclicked I want it to open up a form with a filter on the form's subform.

Open frmMain where frmMain.sfrmForm1.[PO Number]=me.[Po Number]

I can't make the filter work.
0
Comment
Question by:Sasha42
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 35061868
Try this:

DoCmd.OpenForm stDocName,,, "[PO Number]=" & Me.[PO Number]

mx
0
 
LVL 77

Expert Comment

by:peter57r
ID: 35061971
This is a duplicate of the poster's Q posted 5 minutes before this one.
0
 

Author Comment

by:Sasha42
ID: 35061976
Sorry the PO Number is a string
0
 

Author Comment

by:Sasha42
ID: 35062000
This is not a duplicate.  One filters from the frmMain.  And one pulls from a different form.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

724 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