Hey there
anyone who helps gets a big kiss!!
I have created a search form that displays the results of the search in another form.
I want to be able to let users either enter the whole name in the field or part of the name eg. B or Black etc,etc. I am using the formula Like[forms]![frmSearch]![Name}&"*". This works fine when I run the query but will only display the results on the form if I enter the whole name. Does anyone know why this is and if so how can I fix it? I need to display all the record results on the same form so have been using a continuous form as the results form.
Any help GREATLY appreciated.
Many thanks
Sonya B
anyone who helps gets a big kiss!!
I have created a search form that displays the results of the search in another form.
I want to be able to let users either enter the whole name in the field or part of the name eg. B or Black etc,etc. I am using the formula Like[forms]![frmSearch]![Name}&"*". This works fine when I run the query but will only display the results on the form if I enter the whole name. Does anyone know why this is and if so how can I fix it? I need to display all the record results on the same form so have been using a continuous form as the results form.
Any help GREATLY appreciated.
Many thanks
Sonya B