Using IIF ()Function to test value of option buttons

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?
 
P

PC Datasheet

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
 

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

Optionbutton Not working 3
Program buttons to create a word document 0
Getting Radio Buttons to work, that are inserted via AutoText 0
How to make repeating drop-down lists? 2
Creating a Search using a combo box and then creating a report. 4
Word OLE to check spelling in text box 1
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Transfer data between two tables 3

Top