Ajax, thanks very much for your code and the explanations. I'll go through it carefully (may take a few days) so I understand what it's doing and then I'll apply the VB. Come back soon. Cheers.
Ajax, thanks very much for your code and the explanations. I'll go through it carefully (may take a few days) so I understand what it's doing and then I'll apply the VB. Come back soon. Cheers.
Hi Ajax, I'm just researching the structure you're written and am having trouble understanding the meaning of:
fltrStr=fltrStr & "," & rst!AssetNamePK
rst.movenext
Thanks.
lets say your assetname table has the following
assetnamePK..assetname
1...………………..abcde
2...………………..cdefgh
3...………………..zyx
4...…………………defqwe
and the user has typed in 'def'
the recordset returns records 2 and 4
so the code is constructing a string which looks like
,2,4
the initial , is dropped further on in the code