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.
Sasha42Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor 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
All Courses

From novice to tech pro — start learning today.