470,609 Members | 1,312 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,609 developers. It's quick & easy.

Display only field values related to previous selected values

Good morning,
I have a table that contains three fields that I would like to
relate one to another, in other words, for example, when I go to the
form and I click on the drop down box for Buildings and select
Building1, when I go to the following field Floors, I would like to
only display the floor values that belong to Building1 so I can select
one of those. Once I have selected a Floor value for Building1, when I
jump on to the other field, Rooms, all I want to be able to display on
the drop down box are the room numbers that belong to the selected
Floor, which belongs to Building1.
Right now, when I go to these fields, regardless of my selection, I
get to display every value out there for all the Buildings, Floors and
How can I restrict Access to display Floors values depending on the
selected Building value and so on?
Thank you for your help.
Elvis V.
Nov 12 '05 #1
0 1683

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by DettCom | last post: by
3 posts views Thread by Iain Hallam | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.