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