passing two control values

[Johnny Drama]

Hello all,

I have a form and when I double click on a field (documentID) it opens a second form which filters for the documentID.

DoCmd.OpenForm "frmPBCdetail", acNormal, , "[documentid] = " & Me.[DocumentID]

I was wondering if it is possible to pass a second control value at the same time that will also be filtered as well.

Thanks

 

[HiTechCoach]

Hello all,

I have a form and when I double click on a field (documentID) it opens a second form which filters for the documentID.

DoCmd.OpenForm "frmPBCdetail", acNormal, , "[documentid] = " & Me.[DocumentID]

I was wondering if it is possible to pass a second control value at the same time that will also be filtered as well.

Thanks

Yes, you can filter by multi criteria.

Try something like:

DoCmd.OpenForm "frmPBCdetail", acNormal, , "[documentid] = " & Me.[DocumentID] & " and [MyOtherField] = " & Me.MyOtherControl

Note the above assumes the additional criteria is of a numeric data type.

if the second criteria is a string then try:

DoCmd.OpenForm "frmPBCdetail", acNormal, , "[documentid] = " & Me.[DocumentID]  & " and [MyOtherField] = """ & Me.MyOtherControl & """"

 

[Johnny Drama]

Worked like a charm. Thanks much!