Results 1 to 2 of 2
  1. #1
    mungyun is offline Novice
    Windows 7 Access 2007
    Join Date
    Dec 2009
    Posts
    1

    Chart with user input


    Hello all,

    I am sure there is a really simple answer to this but i have been having a heck of a time finding what im looking for by searching so hopefully someone here can help.

    I have a chart on a form that runs a query. It works fine except I want to allow the user to enter a date from and date to on that screen, hit the 'go' button and update the chart with those date ranges.

    My question is how do i tie those date textboxes to the criteria of my query when the user hits the update button?

    Or even, how can i change the charts query on the fly through vba?

    Thanks for any help!

  2. #2
    ChrisO is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2005
    Location
    Brisbane, Australia
    Posts
    27
    The chart has a Row Source property.
    That Row Source property can be either a saved Query or an SQL string.

    If an SQL string, write the SQL string in VBA using the Date range on the Form.
    Then set the Row Source of the chart to the SQL string.

    If a saved Query, set the SQL property of the Query to the SQL string and re-query the chart.

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

Similar Threads

  1. Replies: 3
    Last Post: 08-25-2010, 09:03 AM
  2. Pie Chart
    By kathy62959 in forum Reports
    Replies: 0
    Last Post: 12-21-2009, 11:34 AM
  3. Replies: 0
    Last Post: 01-18-2007, 07:07 PM
  4. Set required user input
    By ZeusOsiris in forum Database Design
    Replies: 2
    Last Post: 12-04-2006, 07:13 PM
  5. ms chart
    By Fredo0709 in forum Forms
    Replies: 0
    Last Post: 12-17-2005, 01:27 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