Terence



1. You should be using Me.FilterOn False . The options are True/False



And when you turn a filter on after it being off I'm pretty sure you have to
requery to refresh the recordset.



2. Are you saying not all of the fields in the bottom are showing? They
should all show unless you specifically hide them.



Regards,

Bill Mosca,

MS Access MVP

<http://mvp.support.microsoft.com/profile/Bill.Mosca>
http://mvp.support.microsoft.com/profile/Bill.Mosca

That'll do IT <http://www.thatlldoit.com/> http://thatlldoit.com

Founder, MS_Access_Professionals

<http://tech.groups.yahoo.com/group/MS_Access_Professionals>
http://tech.groups.yahoo.com/group/MS_Access_Professionals





From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of buffalome90210
Sent: Saturday, July 11, 2009 4:00 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] About my post re split forms and controls dissapearing








I have been playiong with them a bit, and reading about somne of the mysterious
quirks.

I have gotten around all the issues I had/have so nothing is eminant.

The two questions I have remaining are:

1. I was able to toggle (programatically) the filter off via Me.filter
NO.....But have not been able to re-0establish the filter....Turn it back on, OR
rest the entire form to its load state....any Ideas.

2. The strange manifestation I saw on the split form, I ralize and accept that
their are quirks, and that my filters may be a bit odd...BUT, I still don't
understand, not accept, that a filtered Split form should have the ability to
make the controls in the form portion "NON Visible" ?...That I fail to
understand..how..why..under any circumstances it should occur.

Terence



[Non-text portions of this message have been removed]