Enabling/Disabling Buttons on Continuous Subform

Posted on 2011-03-05
Medium Priority
Last Modified: 2013-11-05
Please see image to help visualize issue.

I have a continous subform (two records displayed in below image), I will sometimes need the "Create/View/Clear" buttons enabled and disabled based on the specific record data.  It appears though, that that buttons on a continuous report can't be enabled/disabled based on a record - instead if one record has the "create" button disabled, they all do on the continous form.  

Can buttons be enabled/disabled based ona record?  
Question by:gcgcit
LVL 77

Accepted Solution

peter57r earned 501 total points
ID: 35044370
"Can buttons be enabled/disabled based ona record?  "

No.  Not possible on a continuous form.

The next best thing is to use Conditional Formatting (CF).

If you use a label instead of a button then you can use CF on the label and that means you can enable/disable the label on a record by record basis.
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft Access MVP)
DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 501 total points
ID: 35044491
I think Peter met to say use Textbox, since Labels do not support Conditional Formatting.  Text boxes support CF.  So, with CF ... you can set a condition to Enable/Disable the text box 'button' (see image for example). Using the text box properties, you can sort of make a text box look like a button.

Based on the 'view' you show above, I would suggest using a Single Form View instead of continuous, that way you can Enable/Disable controls in the Form Current Event - based on whatever conditions.

LVL 77

Expert Comment

ID: 35045167
Thanks mx - you're right.
I sometimes use a label to get a coloured 'button' and was confusing the two situations.
Textbox with CF it should be.
LVL 86

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 498 total points
ID: 35045964
You could also include the buttons on the Main form and use code to work with the data on the subform, if that makes more sense.

Author Closing Comment

ID: 35083591
Ended-up locking and unlocking the  on variables on the specific record.

Thanks to all the experts who provided suggestions, they all built towards me coming up with a solution.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

624 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