Results 1 to 3 of 3
  1. #1
    rstonehouse is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Location
    UK
    Posts
    5

    Post Button hiding when filter on

    Hi,



    I have a form for a table which on entry filters by form.

    ON the form I've got a button which toggles the filter and when data is inputted to the form effectively searches.

    The problem is that when the form is in filter by form mode the Search button is greyed out and can't be clicked on

    Is there any way around this?

    Thanks

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    I don't like using the Filter. I prefer to utilize criteria within the recordsource of the form.

  3. #3
    rstonehouse is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Location
    UK
    Posts
    5
    thanks for you reply, I decided to put the command buttons on a pop up window with no border

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

Similar Threads

  1. Filter button
    By tomeem in forum Access
    Replies: 0
    Last Post: 08-28-2009, 12:50 AM
  2. Create "reset filter" button
    By vanlanjl in forum Access
    Replies: 0
    Last Post: 03-03-2009, 07:36 AM
  3. Hiding subreports
    By aouellette in forum Reports
    Replies: 0
    Last Post: 09-12-2008, 08:02 AM
  4. command button to filter a subform issue -
    By countdrako in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 11:58 PM

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