Form not communicating with table

  • Thread starter Thread starter Ancil Jones
  • Start date Start date
A

Ancil Jones

I have a database that has been working fine until I make
some minor changes (changed the looks appearance of forms
and hid unnecessary buttons) for another platform
performing basically the same function. Now I find that
the primary form will take the information, privide the
control number, track the control number, but will not
write the data to the table. I have also found that the
other tables are not abiding by the relationship
restrictions.

The changes I have made are strictly cosmetic. I have
made no changes to the basic structure of the database,
therefore have no idea why it should have decided to stop
cooperating.

Any assistance in this matter would be greatly appreciated.
 
Hard to determine the problem, but here's some ideas:

- Check the form's Record Source property, and verify that
it is based on your table, or on a query based on this
table.

- If it is a query,run it on its own, and attempt to edit
data directly. If it will not allow it to do so, the
query is a non-updatable recordset. A Google search can
identify what causes a recordset to be non-updatable.

If this is not helpful, please post additional detail on
the form's record source.

HTH
Kevin Sprinkel
Becker & Frondorf
 
Back
Top