Updateing info from one table to another

I'm trying to Update one table with info from another table this is the query that I'm using
The problem that I'm having is that its popping up a window for data as if there is a parameter there. this is what I don't understand. I'm coming from a background of t-sql so I'm not entirely familiar with how access works. What I want to do is update a column in the formula table with there corasponding rows in then temp formula table so that if the formula exsists in the formula table then it will move the notes for that formula from the tempformula table to the formula table

that's be best I can think of for explaining it, if you need any more info i would be glad to help

Nathan

re: Updateing info from one table to another

Check out line #4. "TempFormula" is missing the "s".

Tip: It's much easier to see when the SQL is laid out clearly.

re: Updateing info from one table to another

Thanks, I can't believe i missed something so simple.

Nathan

re: Updateing info from one table to another

No worries. It's much harder to see when the SQL is laid out simply as it comes. I always reformat my SQL when I'm working on it.