I am attempting to create a form (Access 2000).

When I use the tools wizard to insert a command button onto the form (such
as a record navigation button or 'open form' button) it generates an error
after the first step in the wizard sequence:
"Method 'module' of object '_form_x' failed".

When I try to use that button, another message appears:
"Error accessing file. Network connection may be lost" (I am not on
network").

The problem seems to have something to do with the table or query upon which
the form is based (the table and query were imported from another database)
.. When I create a brand new table and new form in the database I don't get
this error.

Is there some way to fix this so that I can insert command buttons into the
form?

Thanks

Gus:
Did you import the tables or did you link them?
If you linked them and then disconnected form the drive they are on
the messages you get make sense.

Good luck

Ira Solomon
On Wed, 19 May 2004 17:16:12 GMT, "Gus" <X@ y.com> wrote:

Hi there,

you could try checking the recordsource property in the forms property
set to make sure its pointing to the correct table or query.

Alternatively, you could use the linked table manager (Tools>Database
Utilities>Linked Table Manager) to refresh the table links.

Another option is making a copy of the offending tables / queries in
the current database then renaming the copies to match the old names
(press F11, right click the table/query > save as... etc...)
This would force access to refresh the references to the tables to
match the new DB.

just a couple of ideas.

hope it helps.

David Thomas.

"Gus" <X@ y.com> wrote