Change text that displays when running query

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top