Change button caption on continuous subform

PeregrinTook · April 16th, 2007, 06:44 AM

Hi all,

I have a master single form containing a current 'user' record, and a linked subform (continuous form) displaying all bookings for that user.

In the subform, next to each record is a command button. For each record, I want the command button's caption to either display 'delete' if the field 'deleted' has a value of 0 or 'cancel' if the field 'deleted' has a value of 1.

So far I have got this code:

Code:

Private Sub Form_Current()

    If Me.Deleted = 1 Then Me.btnDelete.Caption = "Restore" Else Me.btnDelete.Caption = "Delete"

End Sub

Which almost works!

The problem here is the subform might display twenty records, and the button caption only changes when you click a record - and in this case it changes the button caption next to every record to either read 'Restore' or 'Delete'.

I'm trying to make it so that as soon as the subform has been requeried, the buttons next to each record change automatically - so some in the list will say 'Restore' and some will say 'Delete'.

Is this possible?

Thanks
PT

sola · April 16th, 2007, 08:00 AM

no to sure,but why dont uuse a field instead of a cmd button.the field will be in the subform table,so whenver the current record is deleted,or restored the field valued will change.
its the field that will bre programmed.

richard_peers · April 16th, 2007, 05:16 PM

Hi PT

As you have found, although the continuous form allows fields to vary from record to record, the definition of other screen objects is singular, and gets replicated across every record.

I've not tried it, but it seems to me that the best way round this would be to have two command buttons, cmdDelete and cmdRestore, both set to display in the same place, and make the appropriate one visible and the other invisible in the FormCurrent event procedure. This also means that you don't need to test the current state of the command button before deciding what to do when the button is clicked!

Give this a try, and report back...

RP