Customising the search record tool

[arobbo]

hi i'm trying to find any easy way to customise the search button you can add to a form. Basically i would like to always default to search in one field and always search any part of the field.

Anyone got any ideas of an easy way to do it i don't want to rewrite the search function in VB really....

Cheers

Andy

 

[SJMcAbney]

To search any part of the field use wildcards.

i.e.

SELECT *
FROM MyTable
WHERE DefaultField Like "*" & [Forms]![MySearchForm]![MySearchTextbox];

Stewart J. McAbney | Talk History

 

[SJMcAbney]

Sorry, pressed Submit too early...

SELECT *
FROM MyTable
WHERE DefaultField Like "*" & [Forms]![MySearchForm]![MySearchTextbox] & "*";

Stewart J. McAbney | Talk History

 

[arobbo]

i didn't really want to use a query...

i could be wrong on this but if you use a query to search for data etc it won't let you modify the data that is displayed. I've been using the built in search for a record button which is basically the same as CTRL and F key , do you know of any way of altering that so function so it defaults to a field and the option search any part of ......

thanks for your reply though

 

[SJMcAbney]

i could be wrong on this"

You most certainly are.

You can also use the form's Filter property.

i.e.

Me.Filter = "[DefaultField] = """ & Me.txtMyTextBox & """"
Me.FilterOn = True



Stewart J. McAbney | Talk History