stLinkCriteria on multiple criteria, different types fo criteria

[crazyhouse]

This is the line of code i am trying to use. It doesnt work. I want the form to open only records that match the inspectjn, and accqty isnull.

inspectjn is text
accqty is a number

stLinkCriteria = "[inspectjn]=" & "'" & [strTrackingNum] & "'" And IsNull([accqty])

Any help would be greatly appreciated. Thanks in advance.,

[Dan2kx]

you got anymore info? do you want the form to only show 1 record? or multiple with 'next'/'previous' buttons, whats the situation? etc..

[DonRayner]

Try your code like this.

stLinkCriteria = "[inspectjn] = " & """" & [strTrackingNum] & """" & " And IsNull([accqty])"

[crazyhouse]

thanks DonRayner, worked like a charm.

Dan2kx, it ends up being one record, but i guess it could have been multiple records. But you bring up something I am interested in. Can i get rid of the previous/next button in code..... so that it can be conditional. Instead of having it either load everytime or not?

[crazyhouse]

nevermind..... silly question. sorry