How do I filter my split form?

[lccrews]

I had a dilemma yesterday with choosing a datatype and I chose text over lookup for a field on a table. But my users still want to be able to add recipe ingredients using a drop down. So I've created a split form from the table and changed the appropriate field to a drop down. The split form was showing all records, so I changed the form record source to a query with 3 fields being linked to another form (filtering out unnecessary records). It worked as a filter, but the 3 fields that I have listed in the query all show #Name? in every record. How do I filter a split form for values I have in 3 textboxes on another form?

[davegri]

When you say "text over lookup" I assume you mean in table design. Even when it's text, you can still use a combobox on your form to allow users to pick a value, and stay away from that split form.
Drag a combobox to the form and using the wizard, set up your dropdown values.

As for the #Name, you'll have to get the query working as a standalone query before it will work as a form's recordsource.