Query Parameter at switchboard not working

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.
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Query problem. Access is my nightmare. 1
From switchboard - do I need a separate form for Data Entry andRecord Edit? 1
Adding data to MS Access from csv file 0
can't add new record to sub-form (continuous) 10
Parameter from switchboard to edit record 1
Slideshow with black border around it 0
macro where statement problem 1

Top