If the form is bound to the query, then closing the form will automatically update the data that are contained in the query, thereby updating the data in the tables. Perhaps we're not understanding your question....?
--
Ken Snell <MS ACCESS MVP>
"T Miller" <TMiller[ at ]discussions.microsoft.com> wrote in message news:E885541E-FDBB-4BAC-BAF7-CA4183183630[ at ]microsoft.com...
[Quoted Text] > that will update a main table the query is attached to on close of the > form > being used? > -- > Thomas
|