473,385 Members | 1,673 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Refreshing a combo box quesry before displaying its contents?

41
Hi,

Basically I have a selection of questions, each with a question ID. For each question there is a combo box which filters out every possible answer except for the answers that correspond with the question ID.

This seems to work OK, for the first click, but after that it will only display the answer set from the first question clicked.

I can’t seem to get it re-queried before it displays the answer set.

This is intended to be on a continuous form so there is a list of questions.

To test it, I have set a button up to run a query for each question and it displays the correct answers, it just doesn’t seem to affect the combo box selection...


the query criteria I run is: [Forms]![question1]![qid]

basically it filters a column I have called "QuestionLink" by a filed I have on a form called qid.

It all seems like it should work, but i just cant get it to refresh the query before showing the drop down list.

Any help would be appreciated
Nov 14 '07 #1
1 1207
ADezii
8,834 Expert 8TB
Hi,

Basically I have a selection of questions, each with a question ID. For each question there is a combo box which filters out every possible answer except for the answers that correspond with the question ID.

This seems to work OK, for the first click, but after that it will only display the answer set from the first question clicked.

I can’t seem to get it re-queried before it displays the answer set.

This is intended to be on a continuous form so there is a list of questions.

To test it, I have set a button up to run a query for each question and it displays the correct answers, it just doesn’t seem to affect the combo box selection...


the query criteria I run is: [Forms]![question1]![qid]

basically it filters a column I have called "QuestionLink" by a filed I have on a form called qid.

It all seems like it should work, but i just cant get it to refresh the query before showing the drop down list.

Any help would be appreciated
Try requerying the Combo Box as in:
Expand|Select|Wrap|Line Numbers
  1. Me![<Your Combo Box>].Requery
Nov 14 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Dave N | last post by:
I have a combo box that displays the names of all the users in my "Users" table. I set the RowSource to a Query from the "User" and "Project" tables. I can select any name from the list and that...
2
by: Jeff Barry | last post by:
Hi, I wonder if any one can help, I'm pretty new to Access and I can't figure out how to change the contents of a combo box based on a selection I make in another. Let me explain I have a...
7
by: Erich Kohl | last post by:
Okay, here's the deal: Let's say a form is based on a table. This form has Field1 (PrimeKey), Field2, Field3, etc. This form also has a subform which shows related records in another table....
1
by: MrPaulC | last post by:
Hey, I wonder if anyone can possibly help me with this problem. I'm really struggling with it. Ok, I have a form with a childform inside it which is in datasheet view, this form has two combo...
0
by: sean.hpr | last post by:
Hi all- I am a vb2005 newb so apologies in advance. Essentially I am having some problems with data refreshing on some of my forms. Background: I have created a project containing a few...
3
by: sparks | last post by:
I have a combo box that when you go to the next combo box it is filtered based on the value in the previous one. so if combo box 1 has fred as its value then combo box 2 has 1 2 3 for values....
33
by: buss123 | last post by:
Hi all, combo box script code was working in IE perfectly with all modes but OnChange event was not working in FireFox(editable mode, if we select valuese that combo box values r...
13
by: mirandacascade | last post by:
I want to set things up such that a section of code will have been executed by the time one clicks on the drop down arrow on a combo box control. Currently, that section of code resides in the...
2
by: mukeshrasm | last post by:
Hi I am printing some text on image dynamically. I am setting the font size and type dynamically and then displaying to other page. Thing is that it is not displaying the image when I click submit...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.