Visible text boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this code placed in on Current in my form:

Private Sub Form_Current()
If Me!Text287 = "0" Then
Me!fcdeed.Visible = True
Me!direct.Visible = False
Else
Me!direct.Visible = True
Me!fcdeed.Visible = False
End If
End Sub

My problem is that if I need to change the information in Text289, my form
does not update. (all the information needed comes from one form)

Any suggestions?
 
We answerred almost the exact same question this morning. Please search the
newsgroup before posting a new thread. Your current ecent fires when you
move from one record to another. You need to ALSO paste this code into the
event that fires when you make a change to the appropriate field.
 
On the after update event of text287 call the on current sub, enter the code

call Form_Current
 
It will be better to call the sub from the after update event, that way you
need to maintain the code only in one place and not two.
 
But then as you scroll through records the appropriate fields will not
appear and disappear. It needs to be in both places.
 
You misunderstood me, I ment leave the on current code, and on the after
update event of the field call the on current event sub, that way it
maintained in one place but run from two.
 
my problem is the form will not update unless I get out the record, when I go
back in the approriate box is visible. (my users input the information
directly into the form, I don't think they will be too happy to go back and
forth)
 
Did you put on the after update event of the field text287 the code:
call Form_Current

So it will visible or unvisible the fields every time you update the text287
field
 
yes, but it is not automatically updating the boxes, I have to go out and
then go back into the record in order to see the change
 
Back
Top