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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

combo box to select criteria

Status
Not open for further replies.

Dumboy

Technical User
Feb 29, 2000
97
US
Hello people<br><br>I'm sure this question has arise before into the dawn of...bla..bla..bla...<br><br>I have a query with a field named group<br><br>can I use a combo box to have the user select the group name and produce a form based on the selection?<br><br>How... how...how...?<br><br>Elizaaaaaabeeeeethhhhhh! <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!
 
Looking at a Combo box <br>[Forms]![FormName]![Combo10]&nbsp;&nbsp;&nbsp;&nbsp;<br>Note the value must be in the &quot;Bound&quot; Column<br>the above works in a query<br><br>Or on in VBA code you can specify which column<br>x = [Forms]![FormName]![Combo10].Column(0)
 
Also see the method in &quot;Using 1 Report Form for several queries&quot; posted today. It's for a report but works similar to a form.
 
Elizabeth...... DougP...... thanks again.....<br><br>I feel like I would like you guys to adopt me......!<br><br>When I grow up I want to be just like you......<br><br>I'll try it........... and put the code on DumboysSourceCode file<br><br>Thanks again <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top