Why can't I filter my form on this field?

[cherold]

I have a form. In that form I have a field called "Media Type". If I right click on that while the media type is vinyl record, the context menu includes entries like "Equals Vinyl Record" and "Contains Vinyl Record". But selecting those doesn't actually filter anything. It still shows every single record regardless of media type.

If I just right click and choose "text filters" and type in "Vinyl Record," then I get an error message that says "Enter a valid value." Since this combo box is based on an ID number in the main table matched to a table of media types, I even tried to put in appropriate id number "1", but while that didn't get an error, it unsurprisingly also gave me 0 records.



What is the problem?

[bgwool]

I'm no expert, but I think that function on the form may be attempting to filter the individual record rather than the record set it is based on, which won't be effective. Instead, you may want to create a query that pulls the records from a table, then filter the query through a function on a form.

[June7]

I cannot replicate the issue. If you want to provide db for analysis, follow instructions at bottom of my post.

[cherold]

I figured it out. I had the field set as a text field instead of a numerical one. Changing that fixed the issue.