issues with assigning control souce to undounded text box

[sparkyinak]

I am missing something obvious apparently. My database (MeDBTable)has an editable drop box for city (MeCityField). On a data entry form (MeEntryForm)has a city field that’s a drop box as well so if the name of the city (MeCityField) is not part of the default list, it can be saved for future use and plugs the new city data in the database where it belongs. It works great.



My 2^nd form is basically a copy and paste of the MeEntryFormwith a couple minor variations that is used just for Sorting and filteringdata. I’ll call this form MeFilterForm. I recently learned while playing with theFilter by Form option that I am not able to filter data in the MeCityField. Figuring that being a drop box and don’t really need a drop box on MeFilterForm, I would replace it with a text box which I know I can filter through Filter by Form option.

I put in an unbound text box in the MeFilterForm and set it’s control source as =[MeDBTable]![MeCityField]. I click ok, close, and save the form. When I open the form, I get the “#Name?” error. When I go in to Filter by Form, Its grayed out and can not filter it. I dug through all my resources andyoutube and found a demo on how to link un unbound field to a database. Uponviewing it, it appeared I did it correctly so I figured it may be a setting somewhere in my file. To be sure, I did a new simple version of my database asI described above. When it came to assigning a control source to the unbounded city field to database, I mimic the video and I still got the “#Name?” so its not my settings. What in the world did I do wrong?

[June7]

Field must be included in form RecordSource. Why are you including table name in the ControlSource?

[sparkyinak]

The city field (MeCityField) was included. The database is in there, when I was learning, it was recommended but not always required. In some cases it is (don’t remember why) but I made it a habit just in case. I removed it and it works. Thanx

[June7]

The table name would be needed if there were multiple tables in the SQL statement and there were multiple fields with the same name.