Can someone please tell me how to update an unbound textbox on a subform? Subroutine says:
If Me.Form.xstatus = 1 then
Me.Form.xtxtbox = "Active"
Else
Me.Form.xtxtbox = "Expired"
but the only thing that displays is #Error. It seems like it should be soooo simple but not!
I can display the xstatus value to the screen okay so I thought that meant the syntax was okay.
strval = Me.Form.[xstatus]
MsgBox (strval)
Please give some suggestions if you can.
Thank you.
If Me.Form.xstatus = 1 then
Me.Form.xtxtbox = "Active"
Else
Me.Form.xtxtbox = "Expired"
but the only thing that displays is #Error. It seems like it should be soooo simple but not!
I can display the xstatus value to the screen okay so I thought that meant the syntax was okay.
strval = Me.Form.[xstatus]
MsgBox (strval)
Please give some suggestions if you can.
Thank you.