Help with Access - Doing a lookup based on selection in a combo box - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

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

07sanchez Avatar
7y, 10m agoPosted 7 years, 10 months ago
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
07sanchez Avatar
7y, 10m agoPosted 7 years, 10 months ago
Options

All Comments

(1) Jump to unreadPost a comment
Comments/page:
#1
is there anyone that can help?

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!