• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

Enabling/Disabling Buttons on Continuous Subform

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?  
ee-subform-.jpg
0
gcgcit
Asked:
gcgcit
3 Solutions
 
peter57rCommented:
"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.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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.

mx
Capture1.gif
0
 
peter57rCommented:
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.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
 
gcgcitAuthor Commented:
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.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now