Results 1 to 2 of 2
  1. #1
    CementCarver's Avatar
    CementCarver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Location
    Canada
    Posts
    231

    Lost My Form Filter

    All of my forms are loaded based on the member_id of the record displayed in the main form. The member_id is passed during the form load event and by the forms open arguments. When I review the filter properties of the forms that still hold the filter, I get Filter=[GROWER].[MEMBER_ID]=39, which is the member_id of the record displayed on the main form.

    But I've lost my filters for my edit forms, which again is loaded based on the main forms member_id record.



    How can I reestablish this filter while editing my forms properties form filter? I've tried to enter [GROWER].[MEMBER_ID] but this does not work.

    So now, when I open my edit form, in the bottom left corner it states that this is 50 of 200 records and says that it's unfiltered. While it should only be 1 of 1 record.

    CementCarver

  2. #2
    CementCarver's Avatar
    CementCarver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Location
    Canada
    Posts
    231
    I don't know why my form lost it's filters, but all I did was import an older form I had, which still had it's filters set.

    CementCarver

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form field name lost
    By jfpmft in forum Forms
    Replies: 12
    Last Post: 11-03-2012, 01:43 PM
  2. Read form info, pass to VB script... lost
    By enragedcow in forum Forms
    Replies: 4
    Last Post: 08-28-2012, 01:11 PM
  3. Replies: 28
    Last Post: 03-08-2012, 06:47 PM
  4. Form that lost its redered record
    By alvaro.mendoza in forum Forms
    Replies: 1
    Last Post: 10-17-2011, 03:06 PM
  5. form lost in gmail
    By vespid in forum Import/Export Data
    Replies: 1
    Last Post: 03-13-2011, 01:58 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums