Change text that displays when running query

G

Guest

I have a button which runs a macro when pressed. This macro in turn runs a
query I have called "Query1" The query is there to move data from one table
to another.

The query asks for a serial number which I have in a table and if one
entered matches one in my table it moves it to another table I have.

When the query runs a pop up box appears asking for a serial number, however
the text in the pop up says: "Forms!Bookswitchout!Serial Number" which is
what I have in the criteria of the query. It then has a text box underneath
to enter the serial number.

I would like the pop up box to say instead "Please enter serial number" Can
this be done? If so how?

Many Thanks.
 
V

Van T. Dinh

You probably has [Forms!Bookswitchout!Serial Number] as the Parameter in the
Query???

If that the case, simply change it to:

[Please enter serial number]

including the square brackets.
 

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

Top