Prev: Command Button Caption on Continuous Form
Next: Help with Dates
From: Dhonan on 4 Jul 2008 14:52
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
From: Allen Browne on 5 Jul 2008 00:43
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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dhonan" <Dhonan(a)discussions.microsoft.com> wrote in message
news:BB798D4F-C03B-483F-9AFA-030D5032780A(a)microsoft.com...
> 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

From: JString on 5 Jul 2008 21:50
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.


"Dhonan" wrote:

> 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
 | 
Pages: 1
Prev: Command Button Caption on Continuous Form
Next: Help with Dates