Trouble with Disappearing Boxes

[ineedaccesshelp]

I have created a form that upon the clicking of a check box, it makes text boxes disappear. However, if you click the check box, it keeps the settings from the previous record (no words in the the text boxes, but the text boxes are still present and the check box still checked like the previous record). How do I make the setting reset every time I open a new record?



Was going to post a sample database to give you an idea of what I am dealing with but for some reason the file size is too big. Let me know how I can shrink the file size as well. I have deleted all the records I can from the database. Direction for if I do get it up are posted below. Thanks for the help!







See my my Database attached and look at my form, RBs Form (ignore the other forms for now). If you check playoff team and start scrolling through the records, you'll see what I am talking about.

Let me know if you have any additional questions and thank you for your help!

[pbaldy]

Typically you'd have similar code in the form's current event to handle the changing of records. If you still need to post the db, normally doing a compact/repair and then zipping will make it small enough.

[ineedaccesshelp]

Thanks for the advice. Here's my sample. Again see directions above.

Practice Database 2.mdb

[pbaldy]

Did you try the current event as recommended? This may help:

http://www.baldyweb.com/ConditionalVisibility.htm

[ineedaccesshelp]

It looks like your controls would accomplish the same thing as mine. Using the example I gave you, how would I input the code?

[pbaldy]

I don't know how to say it any differently. You need the same code in the form's current event ("On Current").

[ineedaccesshelp]

Where do I find this "On Current"/current event space under the properties? Also, I was just seeing if you could try your code out on my db I sent you. Just so you know the code I have been using for the event procedure in my db is:

Private Sub Playoff_Team_AfterUpdate()

If (Playoff_Team = True) Then
Bonus.Enabled = True
Bonus.Locked = False
Bonus.Visible = True

Else
Bonus.Enabled = False
Bonus.Locked = True
Bonus.Visible = False

End If
End Sub


Any way to alter this to accomplish my goal?

[pbaldy]

See attached.

[ineedaccesshelp]

Got it! It took me a second to realize I had to leave the AfterUpdate entry as well, but the OnCurrent did the trick! Now, I need to present one more variable. I have to do it for multiple boxes on severals tabs on the same form that are pulling information from one database. Do I need to put an "End If" at the end of each sequence and then an "End Sub" at the very end or do I need do it another way? Thank you for your patience and help!

[ineedaccesshelp]

Looks like I got it figured out! Thanks for your help!

[pbaldy]

No problem, glad you got it sorted out.