If it's popping an Error on
stLinkCriteria = "[Service Tag]=" & Me![search]
which uses the correct syntax if [Service Tag] is defined as a Number Datatype, one has to assume, given its name, that it is actually a Text Datatype, in which case the correct syntax would be
stLinkCriteria = "[Service Tag]='" & Me![search] &"'"
although you don't need the Square Brackets around Search, and I'd probably write it simply as
stLinkCriteria = "[Service Tag]='" & Me.search &"'"
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007