Changing visibility of textboxes and labels in runtime in ms access?

[HiGu]

On a subform I have two textboxes and 2 labels of which I would need to change visibility on click of a label on the mainform.I do not know where to do this as the textboxes in the main form are not identified on the subform and vice versa.Can someone help me out?

[hjozinovic]

hi HiGu,
Here is how you refer to subforms and controls on it. Let's assume:
Subform name: "sfSubForm"
Label on the subform: "lblLabel"
Your code to hide label on the subform should be:

Me!sfSubForm.Form!lblLabel.Visible = False

Change False to True if you want to show the label.

[NeoPa]

Referring to Items on a Sub-Form should help with that HiGu.

[HiGu]

hey,thanks both of you.This seems to be working fine.

[HiGu]

Hi hjozinovic, your code worked wel while changing value of a textbox but not for changing captions.The one that worked for captions was the following that is referred in NeoPa's post.

Forms("frmWOMAINMENU").[frmWOMAINSUBMENU].Form.[lblhrs].Caption = "hrs"
 

But I could not change controlsource of some textboxes on the same subform using the above methods.

[NeoPa]

Yes. It should work the same way. If you have a problem though, you need to post it (properly - not like this) in a new thread with the associated details included.

[HiGu]

I have just started a new thread on the same.You may delete the above posts {Since deleted -NeoPa} as they make no sense but I'll be grateful if you answer my new thread.

[NeoPa]

Posts deleted HiGu, but if you post the link to the (specific) new question in here then I can look at it more directly for you. It may not be something I can help with butI can at least look.