update query help

[amna77]

hi I have 2 fields in my update query, one is txtPartNum and other one is txtBaanNum. txtBaanNumber I want to update, it should equal to txtpartNum. so what ever value is in txtpartnum, should update table, so that txtbaannum will have same value as well. when i view the query then it gives me right data, but when i click on run, then it does not update the table. why?

 

[GingerR]

What is your sql code of your query?

 

[amna77]

its update query and in the TxtBaanNUmber field,its like that
Field=txtbaannum
Table=tblparts
Update=[txtpartnum]
when i view the query, it puts the same value like txtpart, but when i run it, it does not update.

thanks

 

[GingerR]

Hi. Please supply your update query here so we can see what you are doing.

If you don't know what I mean, open your query in DESIGN MODE. From the menu pick VIEW + SQL VIEW. copy that code and paste it here. Thanks.

 

[amna77]

UPDATE tblParts SET tblParts.txtBaanNum = ([txtPartNum]);

Its working now, actully I closed the database and open it up again, it worked.
so thanks for help.