How to create a wildcard search form (with Base/FireBird)?

edit

Awesome, thanks! I did try the Refresh Form under the subform (that was also in the tutorial), but the real difference is the query. In the tutorial the user parameter is bound to the master field by using the master and slave field configuration - I guess that's outdated.

One thing I was wondering: does the Refresh Form action always save entered values?

Small related follow-up: would making Enter key press in the search field do the form refresh action be done via a macro or is there another way?

@arjan Glad you are satisfied with the result. Have no idea why the tutorial uses a parameter. Have been doing it as posted for years. As stated, the video tutorials are not for me.

As for the entered value, since the text box is tied to the field, when you click the button you are actually going to the sub form which causes the main form record to be saved. You can prove this by closing the Base file, re-open it then examine the record. The vale is still there.

Have many variations posted in Ask using filtering. Just search on table filter. Many answers have links to other tutorials on the subject. Single and multiple list box selections with & without macros are present.

Just saw your last comment. You can use a macro to activate the search by pressing enter key. If you don't find it with the above mentioned search, please leave a note and I'll locate an appropriate post.

Thanks again! I generally prefer text/blogs/etc (in this case I used seek ahead and play at 1.5x speed to mitigate the downside of video), but I found this series to be very a instructive introduction if you know nothing about how Base works (lots of things are not exactly intuitive even if you know SQL).