Command BUtton Caption on continuous forms

[Dhonan]

have a continuos form with a command button that I would like the caption of
that command button to change depending on the transaction type of the record.

For example, if the first record displayed is transaction type "123" then
the caption should be "display report for trans 123".

If the second record is transaction type "456", then the caption should read
"update trans 456".

I have tried using "on current", but that changes the caption on every
button on every line.

Any help would be appreciated it.

Thanks

 

[Allen Browne]

You cannot selectively change the caption on different rows of a continuous
form.

It may be possible to fudge it by leaving the button with no caption, and
placing a text box on top (or by formatting a text box to look like a
command button.) The text box can have an expression in its ControlSource
that handles the various conditions, and it has a Click event (or Enter to
SetFocus to the command button.)

 

[JString]

It sounds like you want that command button to perform different tasks
depending on the transaction type. It might be easier to create different
forms for each type of transaction, and then set the source of each of those
forms to seperate queries that filter your table data according to
transaction type.