Hidden Field

[rgreene]

I have a tab form which I use to track computer hardware and software along with a few other items. On the software tab I have a yes/no box for a specific program called Bridge (Field is called Bridge). Each person that has Bridge is assigned a specific Bridge id(s) (LT001). What I'm trying to do is for it to look and if there in NO check mark in the Bridge field then I don't want the Bridge_Session_1 field to be visiable. If the Bridge field is checked then I want Bridge_Session_1 visiable.
I have the code setup using if/then/elseif statement and it works. I have the event procedure setup on the After Update property of the Bridge yes/no box. My problem is that if I uncheck this box then the other field disappears (like it should) but when I scroll to the next record the field is hidden there as well even if there is a check in the Bridge box.

I hope I haven't confused everyone too much. If I have let me know and I'll try to explain it better.

Thanks in Advance

Rick

 

[Kraj]

If you add the same code to the OnCurrent event, it should redo the check for visible/invisible each time you go to a new record.

 

[rgreene]

That's what I needed Thanks!!!!

How about this one...
is there such a thing as a If...And...Then statement?

If a = True AND b <> null then
C

 

[Kraj]

I'm really not sure. Try it; the VB editor will let you know if you've written a bad statement.

If it doesn't work, you should be able to do a nested IF, which basically does the same thing, just in extar steps.

IF a = True
IF b <> null
THEN
C
ELSE

etc.

 

[jfgambit]

Example of a If w/And:

If ckBridge = True AND IsNull([txtBridge]) then
msgbox "Please enter a Bridge Name",vbOKOnly, "Bridge Name"
Me.txtBridge.SetFocus
Else
End if


HTH