Full Version: IF query question
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
Sitethief
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.

Example:

1.2.3
fish.salt.list of salt fish
fish.not salt.list of not salt fish
schroep
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 .
Sitethief
I don't know if it's fully clear what I meant because my English is not always that bright.
I made an screenshot to clearify things.
Klick

Edited by: Sitethief on Tue Nov 1 19:07:22 EST 2005.
KenSnell
You cannot do this in a table. You're using Lookup Fields in the table, and they cannot be manipulated.

schroep'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.