Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Plymouth, UK
    Posts
    59

    Unanswered: Report selection

    Is their any way that a user can type in the criteria for a query?? e.g.

    I have a report running called Query A,

    This query has records which will need to be removed by a user, so the SQL view or the simple design view will be useless and confusing, can their be a pop up asking for the criteria??

    When you open it, up pops Search for records which match ......???

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    In the criteria protion of your query enter the following

    [Enter you search Criteria]

    The when you open you query or report you will get a little pop-up saying "Enter your search Criteria" and will wait for that information.

    You will want to change the messages so that they are meaningful.

    S-

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •