Coworker modified base query, now form does not allow access to query.

[Brainwave Surfer]

Coworker modified base query, now form does not allow access to query.

is there a place where we can force the form to update it self to access
the same query again?

it looks like there is no data in the table.

 

[Jeff Boyce]

If the query was modified, I don't believe there's a record in Access of
what the previous version was. Do you have a backup copy of the database?

 

[Brainwave Surfer]

If the query was modified, I don't believe there's a record in Access of
what the previous version was. Do you have a backup copy of the database?

Yes, we do, but what I wound up doing was createing a new form via the
wizard, to test out the query. it seems that one of the query base
tables' design was modified to have an autonumber key, thereby breaking
the update capability. I found that out by seeing that the query itself
was not updatable, but when I fixed the query, the form did not follow
suit. I tried resetting the table def in the form properties, checked
all the fields, etc, to no avail. I renamed it and kept it to keep
doing the autopsy so we can understand what happened rather than just
make a new form.

we're going with the new form for now, tho... ;-)

Jim

P.S., thanks for your help and suggestion.. the backup would not have
worked, since the data table had columns added, and data entered. sigh.

its still mildly bugging me about that form, tho... but it's windows...