I'm wondering if there is a way to determine how many rows were updated by a query I run using VBA. Some background. When a user clicks a button on a form an update query is run. If no rows were updated I want to stop the rest of the code from executing. In order to do this I need to determine how many rows were updated. Ideas?

Well, one way is to have a field in the table that has the date and time that record was last updated. You could find the latest one by using the DMax function and save that value in a variable. Then you would run your update query as usual making sure to store new values for the update date and time. Next, check the table again to see how many records have an update date and time greater than the variable you first stored.

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Oh, almost forgot... use the DCount function to get that number I mentioned.

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

Thanks for the feedback. I wasn't aware of that function. I'll give a go tomorrow and see if that doesn't solve the problem I was having. Thanks Again.


















1