Access Newbie! In Access table how do you get field 2 to display data dependant on option selected in field?
Scenario posed: In Access, you have a table with two fields, 1st field is "Call" and has 2 options (drop down list) 1) Phone during office hours, and 2) Phone out of office hours
2nd field is "Number" and has 2 telephone numbers as options (drop down list)
Is it possible on the basis of the option chosen in field one, to force field 2 to display the corresponding telephone number ie either the office or home number?
Would this be done in a separate query with an IF statement or calculated field or something along those lines?
Can anyone make sense of what is trying to be achieved? Any help gratefully received!
Possibly related posts: (automatically generated)
- Related posts on Access
- India to send letter to US for access to Headley | ICT magazine
- Broadband Gives You Access To The Internet, Phone And Tv ...
- Access 2003 for Starters: The Missing Manual: Exactly What You ...
- Related posts on data
- Job & Business | Data Warehousing and Sap Bw
- Lynn Barak » Blog Archive » Hard Drive Data Recovery – The Problem ...
- Webs CEO: Facebook Connect Is The Future, Data Portability No Big Deal
- Related posts on dependant
- Truth About Fat Burning Pills | Acai Berry Weight Loss 4 U
- MAC mb990ll-a – Purchasing the very best Laptop For Your needs ...
- Travel Blog - The Bottom Line on Yacht & Boat Charters
 |
US $24.99
Tagged with: Access • data • dependant • display • Field • Newbie • option • selected • Table
Filed under: Telephone Table FAQ
Like this post? Subscribe to my RSS feed and get loads more!
………..
Access Newbie! In Access table how do you get field 2 to display data dependent on option selected in field?
There are several approaches to this and it will depend on what you intend to do with the second field (later on).
If you want to just show it based on the drop-down of the first field, use a simple expression (probably an IIF will do the job).
For example, Field1 is called [Field1] in the the second field you would write something like…
= IIF ( [Field1] = “Phone during office hours” , “0123456789″ , “9876543210″ )
I personally would use a table with two fields (one for the narrative and the second one for the phone number) and display both in the same drop-down box. You can then use a simple expression to refer to the first drop-down box’s second column by using the ‘Column’ property (see Access help on drop-down lists and ‘Column’ property).
Hope this helped.
Ben Beitler