In Filter by Form how do you make a button visible

[GenieTR]

I have a filter button when click, puts the form in filter by form mode. I have a button on the form which is not visible, but I want it to be visible in the filter by form mode. How can you do this, I tried:

Me!frmEdit.cmdApplyFilter.visible = true

got a an error message.

Thanks in advanced

 

[WildHare]

1) what error message do you get?

2) You don't really need both the shorthand ME and the formname. The ME replaces the form name.

try ME!cmdApplyFilter.Visible = true

instead.

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[GenieTR]

Initially, the syntax was:
forms!frmEditbyfilter.cmdApplyfilter.visible = True

The message is:

You can't assign a value to this object

Thanks again