Solved

Trying to hide value in a form field until another field = "Y"

Posted on 2014-02-08
2
495 Views
Last Modified: 2014-02-13
I have 2 fields on a form.  The first one is a value list field and the choices are either "Y" or "N".

The second field is a calculated field being calculated in the query which the form is using as its record source.

But I want the value in the second field to be hidden until the value in the 1st field = "Y" and I can't seem to make it happen that way.  The value in the second field displays no matter what.

--Steve
0
Comment
Question by:SteveL13
2 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 39844459
In the AfterUpdate event of the List Control add something like this:
Me.NameOfCalculatedControl.Visible = (Me.NameOfListControl = "Y")

Open in new window

Then in the OnCurrent event of the form call the AfterUpdate event of your list control:
Call NameOfListControl_AfterUpdate

Ron
0
 
LVL 20

Expert Comment

by:clarkscott
ID: 39845166
I was going to suggest another way... but Ron's is perfect.

Scott C
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now