Using IIF ()Function to test value of option buttons

  • Thread starter Thread starter v.stopford
  • Start date Start date
V

v.stopford

I want to display a list box with data only if an associated option
button is checked. What is the syntax I should use, please?
 
Put the following code in the AfterUpdate event of the Checkbox:

Me!NameOfListBox.Visible = Me!NameOfOptionButton


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Easy Option Button Question: 8
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Access Create option group without using wizard? 2
IIF Function 2
Limits of IIF? 4
Re: Pass field value selected in Combo Box to SQL Query 1
Lab Value with iif function. 1
Multiple iif challenge 2

Back
Top