Text box based on form entry

[Papa Jonah]

I have a form with a subform.
I want the form to display a label or text box that says "Deleted" if my
delete checkbox is checked on the subform.
I also want the same label or text box to appear on a report that refers to
the same record.

Any thoughts would be most helpful
TIA
Papa

 

[Marshall Barton]

I have a form with a subform.
I want the form to display a label or text box that says "Deleted" if my
delete checkbox is checked on the subform.
I also want the same label or text box to appear on a report that refers to
the same record.

Try setting the main form text box's expresson to something
like:

=IIf(subformcontrol.Form.deletecheckbox, "Deleted")

Use a similar text box expression in the report.

 

[Papa Jonah]

Marshall,
This doesn't seem to work. It doesn't seem to allow for the status of the
checkbox. Granted, I'm no expert, but it seems to say, if the checkbox then
"deleted".
What am I missing?

 

[Marshall Barton]

I don't understand what you mean by:
"It doesn't seem to allow for the status
of the checkbox."

A check box value should be either True or False and the IIf
condition looks at the value and returns "Deleted" if that
value is True or Null if the value is False.

What information is:
"This doesn't seem to work."
supposed to provide beyond the fact that you don't like the
result?

 

[Papa Jonah]

Marsh,
What I meant by "It doesn't seem to work" is that regardless of the "status"
of the checkbox (checked or unchecked) the text box doesn't change. My
inquiry about the status, although it may have been a stupid question, is
because I don't understand how the syntax works. My limited understanding is
why I posted the question in the first place. So thank you for explaining
how this statement works. I'm a little smarter now.
Now I guess I just need to better understand where your command needs to go.
I put it in the control source for the text box. The result was a blank
square in the middle of my form that never changes in spite of the status of
the checkbox in my subform.
Specifically, this is what I am using:
=IIf([sfrmMeasureChanges].[Form].[cbxdeleted],"Deleted")
I also tried putting the same thing in the Before Update event. Same result.

Thanks for trying to help. I'm trying to get smarter.
Papa

I don't understand what you mean by:
"It doesn't seem to allow for the status
of the checkbox."

A check box value should be either True or False and the IIf
condition looks at the value and returns "Deleted" if that
value is True or Null if the value is False.

What information is:
"This doesn't seem to work."
supposed to provide beyond the fact that you don't like the
result?
--
Marsh
MVP [MS Access]

This doesn't seem to work. It doesn't seem to allow for the status of the
checkbox. Granted, I'm no expert, but it seems to say, if the checkbox then
"deleted".

 

[Marshall Barton]

Maybe the text box need to be recalculated when the subform
check box changes. Let's try a different approach.

Put this code in the check box's AfterUpdate AND in the
subform's Current event procedures:

Parent.[the text box] = IIf(Me.cbxdeleted, "Deleted", Null)

I can't be sure without more information, but the report is
probably a different situation. I expect that the check
box's Yes/No field would be in the report's record source
table/query so all that fooling around in the form should be
unnecessay.
--
Marsh
MVP [MS Access]

What I meant by "It doesn't seem to work" is that regardless of the "status"
of the checkbox (checked or unchecked) the text box doesn't change. My
inquiry about the status, although it may have been a stupid question, is
because I don't understand how the syntax works. My limited understanding is
why I posted the question in the first place. So thank you for explaining
how this statement works. I'm a little smarter now.
Now I guess I just need to better understand where your command needs to go.
I put it in the control source for the text box. The result was a blank
square in the middle of my form that never changes in spite of the status of
the checkbox in my subform.
Specifically, this is what I am using:
=IIf([sfrmMeasureChanges].[Form].[cbxdeleted],"Deleted")
I also tried putting the same thing in the Before Update event. Same result.