I have a text box "calcPOB1" that calculates the number of days to an event.
I have a text box "txtPOB1" that displays this data and is bound to a table.
I have yet another text box "finPOB1" that I want to display the final result of my quest: "closed" or "open" based on this criteria:
if the result of is less than or = 0 then "open"
if it's > = 1 then display "closed"
right now I have it in the 'on current' section but it doesnt work.. I tried it in the 'before' section but it's not working there either. Here is what I have as code..
this is the last part of my project.. this project is going to kill me!!
What am I doing wrong???? PLEASE HELP
Thank you
Me!txtPOB1 = Me!calcPOB1
Me!txtPOB2 = Me!calcPOB2
Me!txtPOB3 = Me!calcPOB3
#If calcPOB1 >= 1 Then
txtPOB1 = "closed"
#End If
#If calcPOB1 <= 0 Then
txtPOB1 = "Open"
#End If
I have a text box "txtPOB1" that displays this data and is bound to a table.
I have yet another text box "finPOB1" that I want to display the final result of my quest: "closed" or "open" based on this criteria:
if the result of is less than or = 0 then "open"
if it's > = 1 then display "closed"
right now I have it in the 'on current' section but it doesnt work.. I tried it in the 'before' section but it's not working there either. Here is what I have as code..
this is the last part of my project.. this project is going to kill me!!
What am I doing wrong???? PLEASE HELP
Thank you
Me!txtPOB1 = Me!calcPOB1
Me!txtPOB2 = Me!calcPOB2
Me!txtPOB3 = Me!calcPOB3
#If calcPOB1 >= 1 Then
txtPOB1 = "closed"
#End If
#If calcPOB1 <= 0 Then
txtPOB1 = "Open"
#End If