need help with command bottom

[ياسر]

All i need is to let the command bottom changes its caption in sub form using
access 2003.
when i click the commandbottom thats named ( need to be approved ) it
changes a check box to be true then i need to change the caption of the
command bottom to be named ( Approved ) but when i did that it changes all
the rows in the sub form thats the problem. not the current row.
so please help me

 

[Al Campagna]

Using a button to set a checkbox to True or False is redundant.
Given that you have a checkbox (ex. chkApproval) on each subform record,
just click the checkbox itself, to toggle the True/False value.

Now... replace your command button with a text control, with the
following
calculation in the ControlSource...
IIF(chkApproval = True, "Approved", "Not Approved")
This text control would "act like" a changing caption for your checkbox.
On each record, if chkApproval is True, the text control indicates
"Approved"
On each record, if chkApproval is False, the text control indicates "Not
Approved'
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[ياسر]

thank you very much But:
what can i do with the last row witch have no inputs and the text you made
is saying not approved so if the user click on the check box it will be true
and approved with no input values in the row .?
please help

 

[Al Campagna]

That's another issue altogether.
And would a user do that?
And how did your original "button" setup handle that situation?

If it's necessary to not allow chkApproval to function until certain
other data items on that record are entered, then Disable the chkApproval
until those data conditions are met.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[ياسر]

Sorry Its Not Working how to fix this?

That's another issue altogether.
And would a user do that?
And how did your original "button" setup handle that situation?

If it's necessary to not allow chkApproval to function until certain
other data items on that record are entered, then Disable the chkApproval
until those data conditions are met.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[GAEL]

All i need is to let the command bottom changes its caption in sub form
using
access 2003.
when i click the commandbottom thats named ( need to be approved ) it
changes a check box to be true then i need to change the caption of the
command bottom to be named ( Approved ) but when i did that it changes all

the rows in the sub form thats the problem. not the current row.
so please help me

FIN

 

[Al Campagna]

The caption of any button on a continuous subform record
will display the same caption across all records... which is what I
explained in my previous posts.
You need a calculated text control to determine the state of
your checkbox, and display the correct text
(Approved/Not Approved)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[ياسر]

thank you For your help

The caption of any button on a continuous subform record
will display the same caption across all records... which is what I
explained in my previous posts.
You need a calculated text control to determine the state of
your checkbox, and display the correct text
(Approved/Not Approved)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Al Campagna]

Replying that... "It doesn't work"... is of no help at all.

Please describe *exactly* what you have done so far, and
include (cut & paste) any code you have at this point.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."