Manipulating list from an other form

[alka]

I have a button in formA. When I click on it I want it to show the listB.



(To show it I used the event code: ListB.Visible = True)

The thing is, listB is in formB (wich is a subform of formA).

Code isnt working because listB doesnt exist in formA, got an error code.

I tried [Form]![FormB].ListB.Visible = True
but it didn't work, I don't think I can do this in an event code.

Thx for helping a geek out.

[pbaldy]

Your syntax isn't correct:

http://access.mvps.org/access/forms/frm0031.htm

[alka]

Your syntax isn't correct:

http://access.mvps.org/access/forms/frm0031.htm

Good to know!

In my case I would use to refer to a control, if i am on main form: Me!formB.Form!ListB.Visible = true ?

[pbaldy]

Looks okay; did you try it?

[alka]

I think my reply didn't work.

In order to make my list visible I would use "to refer to a control" from "main form": Me!Subform1.Form!ControlName

Me!FormB.Form!ListB.Visible = True

(I'm trying it atm but it is not working, my form name is not formB but actually something like "the form (b)". Do I need to write it like "the_form_(b)" in the event code?

[alka]

Just created a form "Test" and a list "ListTest". Added that to my formA and the code Me!Test.Form!ListTest.Visible = true IS WORKING.

I just need to know how to correctly write down "the form (B)" in event code

[alka]

Me!("The form (b)").Form!formB.Visible = True

[pbaldy]

Because of the inadvisable spaces and symbols it has to be bracketed. Try

Me![The form (b)].Form!ListB.Visible = True

[alka]

Thanks alot for the help!

[pbaldy]

No problem, and welcome to the site by the way!