Enter Parameter Value Message

[Lesley]

I've converted a select query to an update query where I'm attempting to
populate a route (number) field into a primary table using
[tablename].[fieldname]. The Select query works just find (show correct data
in View). However, when I try to Run the update query I'm prompted to enter
a parameter for [tablename].[fieldname].

Why am I receiving this prompt? HELP!

 

[KARL DEWEY]

You might not have an exact match when it was typed.

Post your SQL.

 

[Lesley]

UPDATE Update_Route_TEST SET Update_Route_TEST.Route =
[Delivery_Table_TEST].[Route], Update_Route_TEST.Stop =
[Delivery_Table_TEST].[Stop];

You might not have an exact match when it was typed.

Post your SQL.

I've converted a select query to an update query where I'm attempting to
populate a route (number) field into a primary table using
[tablename].[fieldname]. The Select query works just find (show correct data
in View). However, when I try to Run the update query I'm prompted to enter
a parameter for [tablename].[fieldname].

Why am I receiving this prompt? HELP!

 

[Lucas Kartawidjaja]

Hi there

Your update query looks a bit strange. In your update statement, you have:
'...SET Update_Route_TEST.Route = [Delivery_Table_TEST].[Route]'

Normally you want to set it to a constant value. Something like SET
Update_Route_TEST.Route = "blah". I believe the reason that Access ask you to
enter the parameter value because it assumed that
[Delivery_Table_TEST].[Route] is a parameter input variable.

I read your first post, when you said that you do a select statement first,
are you by any chance trying to update multiple records at once? It seemed
like you are trying to use the select statement result to do the update?

Lucas

UPDATE Update_Route_TEST SET Update_Route_TEST.Route =
[Delivery_Table_TEST].[Route], Update_Route_TEST.Stop =
[Delivery_Table_TEST].[Stop];

You might not have an exact match when it was typed.

Post your SQL.

I've converted a select query to an update query where I'm attempting to
populate a route (number) field into a primary table using
[tablename].[fieldname]. The Select query works just find (show correct data
in View). However, when I try to Run the update query I'm prompted to enter
a parameter for [tablename].[fieldname].

Why am I receiving this prompt? HELP!

 

[John Spencer]

First, if you are referencing another table you need that table in your
query. Since you didn't reference the table Delivery_Table_Test in your
query, the query has no idea of its existence or any values it might have.

There should either be some relationship between the two tables or
Delivery_Table_Test should be a single record table. To get a more
comprehensive answer you need to post some details about your table
structure, what you are trying to do, and why you are trying to do it.

If you can write a select query with UpDate_Route_Test and
Delivery_Table_Test that shows the records to be updated and the values in
Delivery_Table_Test that you want to use to update UpDate_Route_Test then
you can probably turn that into an update query to accomplish what you need.

UPDATE Update_Route_TEST SET Update_Route_TEST.Route =
[Delivery_Table_TEST].[Route], Update_Route_TEST.Stop =
[Delivery_Table_TEST].[Stop];

You might not have an exact match when it was typed.

Post your SQL.

I've converted a select query to an update query where I'm attempting
to
populate a route (number) field into a primary table using
[tablename].[fieldname]. The Select query works just find (show
correct data
in View). However, when I try to Run the update query I'm prompted to
enter
a parameter for [tablename].[fieldname].

Why am I receiving this prompt? HELP!