Page won't Requery
Posted on 2011-03-08
I have a simple equations that if a text box equals zero value then the "Closed" check box equals true to show that the order is closed. My issue is that this only works if the form is closed then re-opened. Say the order is 10 and we ship 5 and I leave the form open and ship the remaining 5 later in the day, the code won't work. Although if I ship 5 in the day close the form then re-open it later in the day the code works. I assume this is some kind of requery or refresh error. I've tried different variations of the requery and refresh without any luck.
Any suggestions on what I'm missing here?
If Me.[Text36] = 0 Then Me.Closed = True