Results 1 to 7 of 7
  1. #1
    DefinitelyMaybe is offline Advanced Beginner
    Windows 10 Access 2002
    Join Date
    Dec 2020
    Posts
    54

    Prompting for Parameter Value after it was deleted from the source

    Hi All,

    I had built a report using a date field from a table. I have since adjusted the make table and decided to remove the date from source. When I run the report which is still referencing the same table, it still prompts me for this field. How can I stop this from happening?



    Thanks in advance,

    Eric

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,460
    remove the date from source
    And that "source" is?
    Remove the date field from the report query and/or remove the control on the report that was bound to the date field. You would also need to modify any expression in a query field or report control that refers to that date field.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,823
    Maybe you still are requiring a sort on a deleted field.

    Click image for larger version. 

Name:	defmab.png 
Views:	13 
Size:	20.8 KB 
ID:	44267

  4. #4
    DefinitelyMaybe is offline Advanced Beginner
    Windows 10 Access 2002
    Join Date
    Dec 2020
    Posts
    54
    Hi Dave,

    Thanks but no sort...

    Eric

  5. #5
    DefinitelyMaybe is offline Advanced Beginner
    Windows 10 Access 2002
    Join Date
    Dec 2020
    Posts
    54
    The date field was part of the make table query that is no longer part of building the new make table. There are no calculations that this field uses and it is was not tied to anything.

  6. #6
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    2,572
    Is the report based on the resultant table of the make-table query and not a query based on that? If yes I suggest you open the report in design view and inspect the Filter and Order properties along with the goup and sort (which I believe you said you already did).
    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  7. #7
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,460
    Or copy, compact and zip a db copy and post here. A left over reference is in there somewhere.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

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

Similar Threads

  1. Query prompting for Parameter Value, Not sure why
    By DefinitelyMaybe in forum Queries
    Replies: 6
    Last Post: 02-06-2021, 05:02 PM
  2. Replies: 5
    Last Post: 11-21-2018, 04:42 PM
  3. Join query is prompting for parameter?
    By tb1150 in forum Access
    Replies: 11
    Last Post: 06-19-2015, 08:36 AM
  4. Replies: 3
    Last Post: 12-28-2013, 09:13 AM
  5. parameter prompting multiple times
    By sandyg in forum Access
    Replies: 1
    Last Post: 08-15-2011, 10:10 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