I have created a form based on a query which prompts for user name and filters the records displayed based on the name value entered. Fine. Now I want to take it to the next level: instead of the user having to type in his/her name, I'd like to a drop-down list of name values to appear, when one is selected the form is then filtered.
I do NOT want to use code. I am convinced there's a (relatively) simple way to accomplish this using basic Access function. From what I gathered on several Access forums, I pieced together the following steps:
1. Created a new form with just one control source (user name) as a combo box. The combo box has criteria attached to the Row Source to display only the users I want.
2. My main form calls this combo box with (what I believed to be) the correct syntax, attached.
Every time I open the form however, instead of a drop-down list based on the prompt, I get the attached error message suggesting Access doesn't know what to do with this prompted field. It's virtually impossible to trouble-shoot because of course when Access can't interpret something it creates a prompt, but in this case I actually want a prompt. Help!