By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,241 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

stLinkCriteria on multiple criteria, different types fo criteria

P: 31
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

Expand|Select|Wrap|Line Numbers
  1. stLinkCriteria = "[inspectjn]=" & "'" & [strTrackingNum] & "'" And IsNull([accqty])
Any help would be greatly appreciated. Thanks in advance.,
Jan 29 '09 #1
Share this Question
Share on Google+
4 Replies


100+
P: 365
you got anymore info? do you want the form to only show 1 record? or multiple with 'next'/'previous' buttons, whats the situation? etc..
Jan 30 '09 #2

DonRayner
Expert 100+
P: 489
Try your code like this.

Expand|Select|Wrap|Line Numbers
  1. stLinkCriteria = "[inspectjn] = " & """" & [strTrackingNum] & """" & " And IsNull([accqty])"
  2.  
Jan 30 '09 #3

P: 31
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?
Jan 30 '09 #4

P: 31
nevermind..... silly question. sorry
Jan 30 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.