Check Query Successful

[boborsipho]

How do I check in VBA/Access (if it is possible in Access) that a update query actually updated something and then use the fact that it updated/not.

I've got a log in form that checks if the username & password is valid, and then Activates the use, if found in the table, as Yes (Activates is a flag). I want the form to close if the user was found, or the system should close if the user was not found.

Thanks
Bob

 

[boborsipho]

NEVERMIND PPL. I've figured it out by myself.
Thanks for your help anyway.