Close form does not unlock source table

A

andy72

Hi everybody,

I have encountered this problem several times and have not been able to find
a solution that I like.

In each case I want to use a single form that allows the user to input
parameters that are then inserted to a SQL statement to create a table. I
want the SAME form to display the data in this table below the input section.

this means that each time the form is opened it will display the results of
the previous query.

ie:
* Open Form to accept input parameters.
* Store the new parameters as variables
* Close the form (and unlock the source table it is linked to)
* Run my SQL statements on the source table.
* Re-open the form to display the new results.

Using DoCmd.Close to close the form does not unlock the table and Access
returns the standard error: Table is locked by another user (my form).

Is there some VBA instruction that will unlock the source table so I can run
my SQL statements?

thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Creating a Search using a combo box and then creating a report. 4
DLookup in Continuous form 0
Can I save a sql statement generated by a search form? 1
Crating User Form to Add Names 1
Table of content - format does not get saved 2
How do I clear a form? 0
Setting column width in a table with a macro is not working 0

Top