var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query Criteria based on Control in Combox and Wildcards
I have a query I want to run where one of the criterion is a value from a combox in a form.
(I am doing this in the Query builder and not VB, just using SQL so you can see the query)
SELECT Field1, Field2 FROM MyTable WHERE Field2 = [Forms]![PickThisForm]![SelectCombox]
My problem is that the data in [SelectCombox] is actually a search string so I need to add a "*" at the end, Right? But ...[SelectCombox] & "*" doesn't work. How do I go about doing this?
I dont no but you can try this
([SelectCombox] & "*")
to use wildcards you should use "LIKE" instead of "=".
WHERE Field2 LIKE [Forms]![PickThisForm]![SelectCombox] & "*"
LIKE [Forms]![PickThisForm]![SelectCombox] & "*"