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.

Nov 30 '06 #1

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 ...

Nov 30 '06 #2

ruthboaz

Try ...

Expand|Select|Wrap|Line Numbers

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

Thanks.. It works..

Regards,
Ruth

Nov 30 '06 #3

MMcCarthy

Thanks.. It works..

Regards,
Ruth

You're welcome Ruth.

Mary

Nov 30 '06 #4