I made a form for my data (no subforms, very simple but 550 records) with a couple image link fields. I didn’t do this under query forms, its just a data form. Context: this is a database for a coin collection, mostly from ebay purchases. In a text field I enter 2021 under the ebay listing title. I have 10 records with a coin dated 2021. I tried wild card: *2021 nothing. The filter navigator pops up as shown here in the pic. NOT one record shows up! Why? I am not a SQL language person, please help. This to me should be so intuitive the way I am doing it, numerous posts on reddit of similar users with this frustration. I used AI and no help. There are no background filters blocking “2021” records from being searched. Please explain simply, as I want a form view of my record and not raw tables as in a query. Thanks.
You are editing the filter, bur not executing. Press the button left from the button, which has just been pressed. It executes the filter.