Help figuring something out.

[Chris]

I have a query that I am using where it prompts me to give some information
and when I enter in the information is generates a list for me. However I am
wanting it to give me a drop down list so that I may choose from a list of
information rather than type it in. From what I have read, that is not
possible with a Query because you can not make the query prompt you with a
dropdown list. I believe that I need to use a form in this process to make
everything work the way that I want it to. I don't quite know how to set up
the form however. I don't know what to make it reverence and how to make it
work. If I could get some help with this I would greatly appreciate it.

In case it is needed the SQL that I am using on my Query is as follows:

SELECT Users.UserName, CompleteList.DirectoryName
FROM Users INNER JOIN CompleteList ON Users.UsersID = CompleteList.UserName
WHERE (((Users.UserName)=[Please Enter First and Last Name]));

 

[kc-mass]

Create a simple form. We'll say its named "frmMyForm.
On the form place a combobox. We'll name it "cboMyCombo".
Hook the combobox to an appropriate datasource that yields the full name.
Select a name in the combobox.

Change the WHERE clause of your query to read:
WHERE (((Users.UserName)=Forms!frmMyForm!cboMyCombo));

Regards

Kevin