In Base, How can I fill in user parameters in a form text box?

[Gturn]

In Base, I created a music database. I’m making a form for viewing the musical talent (:TalentName) based on a rating (:Rating_1_10) with user parameters. How can I fill in the user parameters in a form text box, instead of in the Parameter Input window? I should also mention that I have so many artists in the collection, that a list box is impractical. Instead, I’m using wildcards in the user parameter for the :TalentName.
(LOWER (“talent-tbl”.“talent-name”) LIKE ‘%’ || LOWER (:TalentName) || ‘%’)
Thanks!

[frofa]

Hello…

You might get some ideas from the sample Base file in THIS POST.

Database filters

My database was created from a spreadsheet. In trying to filter data for a mail-merge: Is there a way to filter by parts of a word or phrase? When I use the Standard Filter, there is the filter ‘Like’, but the case and everything must exactly match. How can I filter for something like “car” that would return entries that ‘contain’: Car, car, NASCAR, carrier, etc. The Standard-Filter choices are: Like, Not Like, Null, Not Null. The answer may be, “Filter data first in the spreadsheet, add …

[Gturn]

Thanks! I will check it out.