Solved

Openform subform filter from another form

Posted on 2011-03-07
4
388 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
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

863 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

20 Experts available now in Live!

Get 1:1 Help Now