combo box query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: lynn atkinson (anonymous_at_discussions.microsoft.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 05:11:56 -0800

I am trying to set up a combo box in which the entries are
based on the content of another field.
ie
I have a venue which may have various rooms avalable.
Venue information ie venue name and venue code, is
displayed on a form (eventschedule). I want users to
choose from a combo box which displays only the rooms for
that venue. (rooms are held in a separate table - rooms).
I have managed to get the combo box to display rooms based
on one venue, but I cannot get this to change. ie at
present it is displaying the rooms available at venue 3.
If I change the venue to venue 4, it still displays the
rooms for venue 3. How do I get it to update the combo
list according to the venue id?
 
I am using (if this helps)
SELECT roomselectqry.[room ID], roomselectqry.[room name],
roomselectqry.[venue code] FROM roomselectqry;

can anyone help.
PS I have looked at the posting on 10th march and tried to
apply this.

Relevant Pages

  • Re: Pearls Before Swine
    ... Scotland, England, France, and then England. ... great band in a small venue at a very accesible point in their career. ... taking your teen and her friends to a concert is a sure sign that you've ... of fate that others display through their consistent absence. ...
    (soc.culture.irish)
  • Re: combo box query
    ... update of the Venue field, so that when I enter the venue, ... the rowsource of my rooms combo should be amended as ... >Private Sub _AfterUpdate ... >>I have managed to get the combo box to display rooms ...
    (microsoft.public.access.forms)
  • Re: combo box query
    ... comboBox in the AfterUpdate eventhandler of the control ... Private Sub _AfterUpdate ... >I have a venue which may have various rooms avalable. ... >I have managed to get the combo box to display rooms based ...
    (microsoft.public.access.forms)
  • ANN: Loebner Prize 2007 US$ 2250 and the Annual Medal
    ... The 2007 Loebner Prize Competition is scheduled for Sunday, ... US$ 2250 and the Annual Medal to the winner ... venue will be made after 1 May 2007; in no case will the date be moved ... 10 Jul 2007 - Opening Date for Receipt of Entries ...
    (comp.ai)
  • Re: AND operator
    ... (Name AND Activity AND Venue) ... "only all the entries for Name with both HQ and Meeting." ... FrontPage Support: http://www.frontpagemvps.com/ ...
    (microsoft.public.frontpage.programming)