Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Queries

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-06-2009, 10:19 AM
Novice
 
Join Date: Apr 2009
Posts: 1
clydet2 is on a distinguished road
Angry Problem with parameter driven combo box

In my data entry table, I have a field called "Makes". It contains 44 records of car makes. I created a Combo Box using another table called "Makes". It worked just fine. I have another field called "Models" and a corresponding table which contains 640 records of car models. This made it a little cumbersome to use in a combo box. I wanted to create a situation where the only records shown in the drop down menu would be the the models of the make I entered in the "Makes" field. I thought I solved the problem by creating a parameter query for the combo box. I simply entered the make and the query would return the models just for that make of car. It worked great except when I tried to enter the next record, I couldn't reset the query for the next record. There dosen't seem to be anything in the marco statements that I can use with the event properties to reset the query. Any suggestions?
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
Problem with Cascading Combo Boxes CushingMT Forms 0 11-13-2008 06:44 AM
Enter Parameter Value plesser Access 1 11-08-2008 07:27 AM
Filtering subform combo from main form combo MUKUDU99 Forms 0 08-17-2008 10:19 AM
Date Parameter shakira Queries 2 03-09-2006 09:55 AM
Add combo box to parameter query louisa14 Queries 1 12-10-2005 05:38 AM


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


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