Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to pull up a selection of data with a drop down button?

Status
Not open for further replies.

MariaL

Instructor
Jun 23, 2003
50
US
Good evening, lets say I have ten people who have one of three positions. In a table, when I name the position on one field, i want a drop down box in the next field showing just the names that apply for that position. Any ideas on how to accomplish this? I appreciate your time and help.

 
Oops,

I thought I was in the VBA/Excel froum.

But let me take a shot.

You select a position.

The result from the Combobox.value becomes the criteria value in query that returns names in that position.

:)

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top