LIKE syntax in a query using a form field

[rkasnick]

OK, I'm stumped. I have a query and in the design grid I am using the following criteria: Like '" & [forms]![fBulkEmail]![text101] & "*' which bases the selection on a field on a form. This syntax returns no records. I cannot find my reference for this and I KNOW it should work, but am sure I have forgotten something. Can anyone point me in the right direction??

Thanks.

 

[KenReay]

Hi

what you have there

Like '" & [forms]![fBulkEmail]![text101] & "*'

is what you would do if you were building the query in code

in query design window, just put

[forms]![fBulkEmail]![text101] & "*"

in the criteria box

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[rkasnick]

Ah, Ken, sometimes the memory gets muddled when you don't use a syntax for a while. Your solution worked great. Thanks.