Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Forms

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-09-2009, 06:17 AM
nkenney nkenney is offline Windows 2K Access 2007 (version 12.0)
Advanced Beginner
 
Join Date: Mar 2009
Posts: 40
nkenney is on a distinguished road
Default Combo box question

Is it possible to do this and if so how...I want to make a combo box with a where clause. I have a custid and a license field. I want the user to be only able to select cars for that customer. I have been able to select the entire table but now want to narrow it down. Both the custid and license are part of the primary table pn the form.Thanks!
Reply With Quote
  #2  
Old 07-09-2009, 06:08 PM
RuralGuy's Avatar
RuralGuy RuralGuy is online now Windows 7 Access 2007 (version 12.0)
Administrator
 
Join Date: Mar 2007
Location: 8300' in the Colorado Rocky Mountains
Posts: 4,263
RuralGuy will become famous soon enoughRuralGuy will become famous soon enough
Default

It sounds like you are talking about Cascading Combo Boxes.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combo box values dependent on selection another combo box lrt Forms 3 02-26-2009 07:17 AM
Filtering subform combo from main form combo MUKUDU99 Forms 0 08-17-2008 10:19 AM
A combo box question GeorgeD Forms 3 05-05-2008 08:53 AM


All times are GMT -8. The time now is 02:37 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.