UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> IF query question    
 
   
Sitethief
post Nov 1 2005, 06:40 PM
Post #1

New Member
Posts: 2
From: Netherlands
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
Go to the top of the page
 
+
schroep
post Nov 1 2005, 06:45 PM
Post #2

UtterAccess VIP
Posts: 5,200
From: Denver, Colorado [USA]
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 .
Go to the top of the page
 
+
Sitethief
post Nov 1 2005, 07:05 PM
Post #3

New Member
Posts: 2
From: Netherlands
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.
Go to the top of the page
 
+
KenSnell
post Nov 1 2005, 09:12 PM
Post #4

UtterAccess VIP
Posts: 1,117
From: Michigan, USA
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.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 11:36 AM