I have a (continuous) form, which contains records from a query, I want to have a command button which will refresh the form to show the latest results of the query - whats the best way of doing this?

Thanks
Ben

I suppose on the footer of this form you can have a command button with this in the button's On Click event: Me.Requery.


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

Thanks Greg that was perfect :)