Help figuring something out.

C

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]));
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top