need help with command bottom

  • Thread starter Thread starter ياسر
  • Start date Start date
Ù

ياسر

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
 
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
 
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?

Al Campagna said:
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."
Click to expand...
 
ياسر said:
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
Click to expand...
the rows in the sub form thats the problem. not the current row.
so please help me
Click to expand...
FIN
 
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
Al Campagna said:
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."
Click to expand...
 
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."
 
Back
Top