Pushing data in a bound text box.

[Jay]

how would you write the code to push an expression into a
bound testbox based on conditions. For example if I had
two text boxes one that had "First Written Warning" and
the second box had "Absenteeism" and you wanted specific
wording pushed into the another bound text box so that it
could be saved in the table here is the expression: =
[First Name] & " " & " was out of work on the following"
& " " & [List156] & " " & "day/s, and did not have accrued
sick time to cover this absence." & " " & [First Name]
& " " & " has recieved a Verbal, First, Second Written
Counseling notice for absenteeism as listed below.
Therefore you are being" & " " & [Level of ] & " " & "for
attendance for a 3 day period to allow you to put your
personal issues in order and improve your attendance. You
are suspended for" & " " & [Date Issued]+1 & " " & ";"
& " " & [Date Issued]+2 & " " & ";" & " " & [Date Issued]+3

 

[Rick B]

Just put a statement in your code to do it. Where you put it depends on
when you would want to update the box. What event should trigger access to
replace the field's value?

Once you determine that, your code would look something like....

[SomeFieldName] = [First Name] & " " & " was out of work on the following"
& " " & [List156] & " " & "day/s, and did not have accrued sick time to
cover this absence." & " " & [First Name] & " " & " has recieved a Verbal,
First, Second Written Counseling notice for absenteeism as listed below.
Therefore you are being" & " " & [Level of ] & " " & "for attendance for a 3
day period to allow you to put your personal issues in order and improve
your attendance. You are suspended for" & " " & [Date Issued]+1 & " " & ";"
& " " & [Date Issued]+2 & " " & ";" & " " & [Date Issued]+3


Post back with more details if you need further assistance.

Rick B



how would you write the code to push an expression into a
bound testbox based on conditions. For example if I had
two text boxes one that had "First Written Warning" and
the second box had "Absenteeism" and you wanted specific
wording pushed into the another bound text box so that it
could be saved in the table here is the expression: =
[First Name] & " " & " was out of work on the following"
& " " & [List156] & " " & "day/s, and did not have accrued
sick time to cover this absence." & " " & [First Name]
& " " & " has recieved a Verbal, First, Second Written
Counseling notice for absenteeism as listed below.
Therefore you are being" & " " & [Level of ] & " " & "for
attendance for a 3 day period to allow you to put your
personal issues in order and improve your attendance. You
are suspended for" & " " & [Date Issued]+1 & " " & ";"
& " " & [Date Issued]+2 & " " & ";" & " " & [Date Issued]+3