Help with Access - Doing a lookup based on selection in a combo box

1 reply
Found 15th Mar 2009
Hi all,

Got a project to do for a University assignment but it is driving me crazy.

I'm doing a course booking database and I have a form where the user is asked to select a location to hold the course, then from that pick a room based on which location they choose.

I have the form working however I can't limit their choice of rooms to what location they have chosen, it simply shows all rooms, but gives an error if you pick a room which doesnt belong to that location.

Can anyone help

Thanks in advance

My Data is (from Room & Location):

ROOM
Room ID (PK)
Location ID(FK)
Room Name
Room Occupancy

LOCATION
Location ID (PK)
Location Name
Location Add1
Location Add2
Location Town
Location Postcode

  1. Misc
Groups
  1. Misc
1 Comment

Original Poster

is there anyone that can help?
Post a comment
Avatar
@
    Text
    Top Discussions
    1. Wireless headphones11
    2. Driving anxiety.2429
    3. I’m in dire need of a dash cam with remote viewing capability over 4G916
    4. THOMSON TUI 2 CRUISE PROBLEM - ANY HELP APPRECIATED44

    See more discussions