Update Query - Enter Parameter Value

[Evans2]

Hi,

I'm trying to run an update query and I keep getting the "Enter Parameter Value" pop up.


Table A is a list of customers with unique customer ID's. Table B
contains data specific to each customer and a blank column called
Customer ID.

I want to use an update query to fill in the blank
Customer ID column in Table B with the Customer ID's in Table A. I've


tried a number of ways but I keep getting this damn Enter Parameter
Value pop up. I don't know what I'm doing wrong.

I watched a work colleague do the exact same thing so I know it works but of course it doesn't when I try it.

I've uploaded pics of both tables as well as my attempt at the update query.

Please help!

Thank you

[CJ_London]

you need to link customerpositionmaster table to the tblcustomer table - looks like on short name

[Evans2]

Thanks! That did the trick.