Results 1 to 3 of 3
  1. #1
    dantejazz is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    10

    Query displays info in Datasheet view - not desired Report

    Good afternoon.

    I'm stumped,...

    Synopsis - Unbound Form with Combo box for Student Name, Begin Date and End Date.
    - Drop-down allows user to select desired Student Name.
    - Date/Time fields allows for Date Range of grades entered into table.

    - Command Button on Form executes Query based on parameters.
    - Query runs perfectly but results show in Datasheet view ONLY.

    - I have a Report built intended to show Query results.
    - Report Properties <Data Tab> = Record Source - (qry_StudentGrades). - Running the Report or the Query directly displays a dialog box indicating that it is looking for the
    Student Name, Begin Date and End Date that was entered into the Form. *Which would be expected if
    designed properly.


    - However, it appears as though the Report is not "linked" to the Query results?!?

    My question is, logic for me would have the Form generate the Query which would, in turn, then generate the Report.

    I realize that this is "Reports 101" for most. lol But, this learning-curve is a bear!

    Thank you.

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Make the query the record source for your report. Your command button will open the report not the query and by referencing the fields on the form as criteria in the query the report will be created correctly.

  3. #3
    dantejazz is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    10
    aytee111,

    Let me begin by saying 'thank you' for responding.

    It may sound simple, but all ofthe programming that I have been doing for years has a syntax of Query first and then choose the output method. This makes sense but completely escaped me.

    It works perfectly!

    Danté

    *This may be coded as SOLVED.

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

Similar Threads

  1. Datasheet view in tab only
    By cdzajp in forum Forms
    Replies: 1
    Last Post: 06-22-2011, 12:44 PM
  2. Replies: 4
    Last Post: 12-01-2010, 02:42 PM
  3. Replies: 4
    Last Post: 10-03-2010, 09:54 PM
  4. Datasheet View
    By Evgeny in forum Programming
    Replies: 6
    Last Post: 04-28-2010, 10:17 AM
  5. Form - Datasheet View
    By kalove in forum Forms
    Replies: 0
    Last Post: 06-20-2007, 11:29 AM

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