[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 431
  • Last Modified:

Openform subform filter from another form

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
Sasha42
Asked:
Sasha42
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Try this:

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

mx
0
 
peter57rCommented:
This is a duplicate of the poster's Q posted 5 minutes before this one.
0
 
Sasha42Author Commented:
Sorry the PO Number is a string
0
 
Sasha42Author Commented:
This is not a duplicate.  One filters from the frmMain.  And one pulls from a different form.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now