Full Version: IF query question
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
I want to make it possible that when a dropdown menu in a certain cell(or colum of cells) has an certain value the dropdown menu in the next cell l(or colum of cells) is different each time the value changes.
fish.salt.list of salt fish
fish.not salt.list of not salt fish
Welcome to UA!
This is done in a form, and is called CASCADING COMBO BOXES.
Do a search here on UA for this topic, you will find many examples. Candace Tripp has a fine example on her web site .
I don't know if it's fully clear what I meant because my English is not always that bright.
Omade an screenshot to clearify things.
Edited by: Sitethief on Tue Nov 1 19:07:22 EST 2005.
You cannot do this in a table. You're using Lookup Fields in the table, and they cannot be manipulated.
chroep's answer pertains to how you do it on a form, which is the way data should be entered/viewed/edited in a database. Do not enter data directly into tables.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.