Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006

    Question Unanswered: Invisible Records Appear On Filter

    hi again,

    I've been hiding records(.visible = false) in some forms and during filter
    BAM they pop out.

    The Filter and Applyfilter events just can't seem to trap this

    am I missing something?

    by the way


  2. #2
    Join Date
    Nov 2003
    Well....simply make your filter....not pull them out of the table(s).

    If you want to be sure of this just add a Yes/No Data Type field to your table and set things up so that if the field is set to Yes then the Record can be viewed. If set to No then the Record can not be viewed. Your filter might then look something like:

    Me.Filter = "[aTableStringField]='" & Me.SomeFormField & "' AND [myTableYesNoField]=True"

    Self Taught In ALL Environments.....And It Shows!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts