CODEWITHSUNDEEP
ms-accesscontinuous-forms
user3688651
user3688651

Reputation: 11

Conditionally disable buttons on continuous forms in Access

I have a continuous form in Access 2010 with a delete button that shows for each record shown on the form. I only want the delete button enabled on the very last record shown. I am stumped how to do it. Any help greatly appreciated. Thanks.

Upvotes: 1

Views: 3068

Answers (1)

user783388
user783388

Reputation:

In access there is only one instance of a component on any form - in continuous forms its just copied several times. The only way you can have anything different on any single row in a contiuous form is through data (obviously) and through conditional formatting of a data aware component: the textbox. And the formatting options are also quite limited. So there are two options: EITHER use a textbox that has the same background as the form and create a conditional format that changes the backcolor for the last row OR create table (ID,PICTURE) with two rows - one with a transparent picture (ID=1) and one with the picture of a button (ID=2) - and link it in the recordsource (Somethig along the lines of: SELECT .... pic FROM yourtable INNER JOIN pictable ON pictable.ID = yourtable.isLastRecord ...

Upvotes: 1

Related Questions