I have an update query that looks for a name eg "first"
then it is suppost to update a field with 1
I have a command button that runs the query
This then says "you are about to update 1 row(s) so i press yes, but the field doesn't update
But if i flick through the database and then come back to the record it has updated
How can i do this so i dont have to flick
Thanks
Andrew
then it is suppost to update a field with 1
I have a command button that runs the query
This then says "you are about to update 1 row(s) so i press yes, but the field doesn't update
But if i flick through the database and then come back to the record it has updated
How can i do this so i dont have to flick
Thanks
Andrew