Results 1 to 3 of 3
  1. #1
    atom is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Posts
    43

    Filter subform on button Click

    I have a subform where I would like to filter it , when user clicks button and get the latest date on my subform .
    I have no idea where to start so if someone could help..


    Thank you in advance

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Can you explain with a little more detail what you are trying to achieve?

  3. #3
    atom is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Posts
    43
    Ok let's assume I have a subform with these fields:

    Product | Price | Date_Purchased


    I want to show records with the latest date(from Date_Purchased) on this subform when users clicks a button.

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

Similar Threads

  1. Replies: 28
    Last Post: 03-08-2012, 06:47 PM
  2. Replies: 1
    Last Post: 02-20-2012, 01:59 PM
  3. Trying to click a button in vba
    By boywonder in forum Programming
    Replies: 8
    Last Post: 05-02-2011, 04:34 AM
  4. +1 on button click
    By 10 Gauge in forum Forms
    Replies: 4
    Last Post: 02-14-2011, 06:51 AM
  5. 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