event help

using the IIF function it now works but any other way , it displays the
message all the time..

Thanks again for the suggestion

Tom



"Clifford Bass" wrote:

Hi Tom,

No. Leave it in the detail. That is where is should be. Do I take it
that it is working now? Or is there still the message for all rows?

Clifford Bass

"Tom" wrote:

The label was in the detail sectio should i move it to a header or footer?

"Clifford Bass" wrote:

Hi Tom,

You are welcome. It is a bit odd, but since you got one method to
work, that is really all that counts.

Clifford Bass

"Tom" wrote:

using the IIF function it now works but any other way , it displays the
message all the time..

Thanks again for the suggestion

Tom

Yes that is all that counts. I was just curious as to why there was no after
update command available on the tab for the label I created since I have done
this before. I even included a checkbox field and there was no after update
event for that either. What dicxtates the availabaility of an after update
event/ Is it only certain types of fields?

Thanks again
Tom

"Clifford Bass" wrote:

Hi Tom,

You are welcome. It is a bit odd, but since you got one method to
work, that is really all that counts.

Clifford Bass

"Tom" wrote:

using the IIF function it now works but any other way , it displays the
message all the time..

Thanks again for the suggestion

Tom

Hi Tom,

Labels do not have events when connected to other controls. But do
when not connected. They would not have an after update since they are not
something the user modifies. Controls on a report do not have update events
since they are only reporting. At least that is my understanding.

Clifford Bass

"Tom" wrote:

Yes that is all that counts. I was just curious as to why there was no after
update command available on the tab for the label I created since I have done
this before. I even included a checkbox field and there was no after update
event for that either. What dicxtates the availabaility of an after update
event/ Is it only certain types of fields?

Thanks again
Tom

There is no After Update event for controls on a report, because
they cannot be updated. Reports only display/print data, they do not
allow updates by the user.

You're thinking of the After Update event for controls on a form, which
are designed for user input/updating. However, labels do not have an
After Update event , even on forms, because they are only for
display. You can update/change their value programmatically, but the
After Update event is related to user updates, not programmatic updates.

Form controls that can actually be updated by the user have After Update
events. The form itself also has an After Update event.

--
_________

Sean Bailey


"Tom" wrote:

Yes that is all that counts. I was just curious as to why there was no after
update command available on the tab for the label I created since I have done
this before. I even included a checkbox field and there was no after update
event for that either. What dicxtates the availabaility of an after update
event/ Is it only certain types of fields?

Thanks again
Tom

"Clifford Bass" wrote:

Hi Tom,

You are welcome. It is a bit odd, but since you got one method to
work, that is really all that counts.

Clifford Bass

"Tom" wrote:

using the IIF function it now works but any other way , it displays the
message all the time..

Thanks again for the suggestion

Tom

That was the problem. Ihad done it on a form not on a report. Thanks for
clearing that up.

Tom

"Beetle" wrote:

There is no After Update event for controls on a report, because
they cannot be updated. Reports only display/print data, they do not
allow updates by the user.

You're thinking of the After Update event for controls on a form, which
are designed for user input/updating. However, labels do not have an
After Update event , even on forms, because they are only for
display. You can update/change their value programmatically, but the
After Update event is related to user updates, not programmatic updates.

Form controls that can actually be updated by the user have After Update
events. The form itself also has an After Update event.

--
_________

Sean Bailey


"Tom" wrote:

Yes that is all that counts. I was just curious as to why there was no after
update command available on the tab for the label I created since I have done
this before. I even included a checkbox field and there was no after update
event for that either. What dicxtates the availabaility of an after update
event/ Is it only certain types of fields?

Thanks again
Tom

"Clifford Bass" wrote:

Hi Tom,

You are welcome. It is a bit odd, but since you got one method to
work, that is really all that counts.

Clifford Bass

"Tom" wrote:

using the IIF function it now works but any other way , it displays the
message all the time..

Thanks again for the suggestion

Tom

That cleared it up . I really appreciate the help. You guys provide a
fantastic service. Thanks again to all of you

Tom

"Beetle" wrote:

There is no After Update event for controls on a report, because
they cannot be updated. Reports only display/print data, they do not
allow updates by the user.

You're thinking of the After Update event for controls on a form, which
are designed for user input/updating. However, labels do not have an
After Update event , even on forms, because they are only for
display. You can update/change their value programmatically, but the
After Update event is related to user updates, not programmatic updates.

Form controls that can actually be updated by the user have After Update
events. The form itself also has an After Update event.

--
_________

Sean Bailey


"Tom" wrote:

Yes that is all that counts. I was just curious as to why there was no after
update command available on the tab for the label I created since I have done
this before. I even included a checkbox field and there was no after update
event for that either. What dicxtates the availabaility of an after update
event/ Is it only certain types of fields?

Thanks again
Tom

"Clifford Bass" wrote:

Hi Tom,

You are welcome. It is a bit odd, but since you got one method to
work, that is really all that counts.

Clifford Bass

"Tom" wrote:

using the IIF function it now works but any other way , it displays the
message all the time..

Thanks again for the suggestion

Tom

You are welcome Tom!

Clifford Bass

"Tom" wrote:

That cleared it up . I really appreciate the help. You guys provide a
fantastic service. Thanks again to all of you

Tom