Enter Parameter Value Error in Macro

[kasimagj]

Hi! So, i'm really confused. I have a macro that's supposed to perform the following (simple) SQL statement:




UPDATE dbo_Bid_Rates
SET dbo_Bid_Rates.RATE_RANK = dbo_bid_Ranks_linked.Rank,
dbo_Bid_Rates.LC_Carr1 = dbo_bid_Ranks_linked.LC_Carr1,
dbo_Bid_Rates.LC_Carr2 = dbo_bid_Ranks_linked.LC_Carr2
WHERE dbo_bid_rates.ID = dbo_Bid_Ranks_linked.ID

For some reason, I get a popup asking for me to enter the parameter values for each of the dbo_bid_Ranks_linked fields (Rank, LC_Carr1, LC_Carr2, then ID).

The fields are spelled correctly and it won't perform the macro function.

WHAT AM I DOING WRONG????? (note: RATE_RANK in RATES table was previously updated, so the macro didn't update it)

picture here: https://docs.google.com/leaf?id=0B3M...wYTlh&hl=en_US

[June7]

Did you use the query designer to help you build and test UPDATE query? When it works properly, put the statement into code.

[kasimagj]

Thanks for the reply. So I've never made an UPDATE query before and i'm having the same error as before. Can you see if I'm missing something?

I took a screenshot of the query design and also the SQL code:

pic: https://docs.google.com/leaf?id=0B3M...mMzYz&hl=en_US

Really appreciate the help! I've been trying to figure this out for a long time xO

[June7]

Since the source data is another table/query, must include it in the query design along with the destination table and join the two on the unique id field.

Access Help has guildelines.