Show/Hide active form

[resolva]

Hey all,

I have tried to use some code from another site to try and get a show and hide form working.

I have attached the database, if you open up the Delegates Form you will see the error. I am basically trying to get it so when you click on the "has paid" checkbox the subform will display.

Thank you very much in advance

 

[boblarson]

First of all, you need a couple of things.

1. You don't have a checkbox on the form called Active (not sure I would call it that but since you do, my code reflects that. That is why you are getting the initial error.

2. Once you put a check box on the form and name it Active then you can use this code in your checkbox's After Update and the form's On Current event:

Me.PaymentIN_subform.Visible = Me.Active

you only need that one line of code.

 

[resolva]

Thank you for the explaination Bob.

However I can't seem to get it working without the error still. Is it possible you could impliment it for me and upload?

I would highly appreciate it.

Thank you very much

 

[SOS]

Thank you for the explaination Bob.

However I can't seem to get it working without the error still. Is it possible you could impliment it for me and upload?

I would highly appreciate it.

Thank you very much

What error? Have you done what Bob said and put a checkbox on your form and named the checkbox ACTIVE in its name property?

 

[boblarson]

Just needed to set the checkbox to False in the form's open event.

 

[resolva]

Im sorry if im being really stupid, but i cant seem to get it working still.

It says "microsoft access cannot find the object ME"

Is the Me supposed to be there before the Active?

 

[boblarson]

I don't see any checkbox in this version? Did you try opening the last one I just posted? It was working fine for me.

 

[resolva]

Sorry bob but the one you posted before didnt relate to my database. It was for another thread I believe.

As you can see it is nearly working now, the form shows/hides but there is a slight error.

Thank you again

 

[boblarson]

Sorry bob but the one you posted before didnt relate to my database. It was for another thread I believe.

As you can see it is nearly working now, the form shows/hides but there is a slight error.

Thank you again

I'll take a look again but in the meantime take a look at what I just posted in that thread (I did goof and so I re-uploaded the correct one).

 

[resolva]

Thank you Bob that works.

I know this is me being a complete pain, but you had made it work with the Active checkbox. How would I make it work with the HasPaid checkbox instead? I want it so that is checked and then the other subform displays so the details can be added.

Thank you