put a search box on a form?

[merlin777]

I'd like to put a search box on a form so the user can search for a record using the title field of 'maintable' and then modify it using the form.

I'm not vba capable but I've seen a method where you add a text box to the form and use the control wizard to turn it into a search box.

The first problem I have is that although the controls wizard appears to be selected, it doesn't open.



Am I doing this wrong?

[June7]

Are you sure that method was for a textbox, not a combobox?

I don't use the wizards. Also don't normally use macros. Review: http://www.allenbrowne.com/ser-62.html

[merlin777]

It definitely said textbox but I'm open to any suggestions that achieves the same thing. I'll even try VBA if someone has the patience to hold my hand!

Mystified as to why the wizard doesn't start.

[June7]

Do you have link to what you saw?

[merlin777]

I added a button and the control wizard appeared so I used "Category-Record Navigation and ACTION-Find Record." which brings up a find and replace box which wasn't exactly had in mind but it'll do for now. I wanted to type a name into a text box and have the form go to that record without all the other settings of the find/replace box.

[merlin777]

Do you have link to what you saw?

I can't find it again I'm afraid. Maybe that advice was in error.

[June7]

The link I provide shows one method of accomplishing. It uses VBA code.

Here is another http://datapigtechnologies.com/flash...tomfilter.html
This uses dynamic parameterized query - which I also never use. I prefer the VBA method.

[merlin777]

Thanks for that.

[Homegrownandy]

A query referencing the text box may do what you want also. Or have you resolved this issue now?

in the criteria for the field you want to search type something like this:

Like "*" & [Forms]![your_form_name]![Search_TXT] & "*" Or Is Null

that will find anything that contains the characters you input. you can be more specific but that's up to you.

[merlin777]

thanks for that. i'll use find and replace for now and then try your method later on.