prompt boxes

• mattbristow

  SSC Veteran

  Points: 240

  More actions

  February 18, 2004 at 2:47 am

  #161146

  Hi all

  In Access when you use square brackets in say a query you can create a prompt box for user defined criteria. Whats the equivalent command when using access as a client for SQL i.e. access.adp  

  Any help greatfully received

• noeld

  SSC Guru

  Points: 96590

  More actions

  February 18, 2004 at 10:41 am

  #494566

  Lets assume you are running a report based on a stored procedure (WITH PARAMETERS).

  1. On the REport Record Source porperty you specify the name of the sp

  2. On the Input parameter Property just specify @paramName=[Enter the value of Parameter 1]

  Run the Report and you will get a "prompt box"

  with Enter the value of Parameter 1

  HTH

   

  
  * Noel