enter parameter value in an update query?

L

Lesley

I have an update query (converted from a select query) where I'm trying to
update/populate a Route field using [tablename].[fieldname]; however, when I
look at the data in View everything looks ok. But, when I click run, I
recieve an "enter parameter value" prompt.

Can anyone tell me WHY I'm getting that message when I'm merely trying to
update the data into another table???
 
P

Paul Overway

Is [tablename].[fieldname] spelled correctly? Is that table included as
part of the query?
 
D

Douglas J. Steele

Are you saying that you're expecting to be prompted for tablename and
fieldname?

Access doesn't allow you to do that. You'll have to build the SQL
dynamically.
 

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

Append Crosstab Query to Existing Table 0
Adding data to MS Access from csv file 0
The usual "Enter Parameter Value" prompt with combo boxes 4
Enter Parameter Value Message 0
Too few parameters error with a IIF statement 5
Enter Parameter Value Message 4
Help with update query and unbound combobox 4
Access 2007 newbie with Form Issues 1

Top