Query Parameter at switchboard not working

  • Thread starter Thread starter p-rat
  • Start date Start date
P

p-rat

I have a selection on my Switchboard for Edit Record. This runs a
macro which runs a query parameter asking for a Ticket Number. The
number entered should pull up the correct Record to Edit, but it's
pulling up any record. Currently I have one record in my system.
Ticket # 12345. In the parameter window I can enter in any number and
it will pull up this record. Does anyone know why this isn't working
correctly. If the record doesn't match any in the system I want it to
either pull up a blank form or have an error message appear. Thanks.
 
Post the SQL of the a parameter query that ask for a Ticket Number.
Open the query in design view, click on menu VIEW - SQL View, highlight all,
copy, paste in a post.
 
Back
Top