DoCmd.OpenReport - stLinkCriteria

[ruthboaz]

Hi,

I have a numeric Field RFINo and a Yes/No Data type for Issued

stLinkCriteria = "[RFINo] = " & lstRFINo.Value & " And [Issued] = Yes"

With the above I am not getting the specific record.

Pls advice.

Thanks & Regards,
Ruth.

[MMcCarthy]

Hi,

I have a numeric Field RFINo and a Yes/No Data type for Issued

stLinkCriteria = "[RFINo] = " & lstRFINo.Value & " And [Issued] = Yes"

With the above I am not getting the specific record.

Pls advice.

Thanks & Regards,
Ruth.

Try ...

   
stLinkCriteria = "[RFINo]= " & Me.lstRFINo & " And [Issued] = -1"

[ruthboaz]

Try ...

   
stLinkCriteria = "[RFINo]= " & Me.lstRFINo & " And [Issued] = -1"

Thanks.. It works..

Regards,
Ruth

[MMcCarthy]

Thanks.. It works..

Regards,
Ruth

You're welcome Ruth.

Mary