form stoped working

[Guest]

I have an accesss form that has fields from several databases on it. After
adding fields from yet another database it no longer lets me add records. It
just beeps at me when I try to edit or add. I've deleted the work I did but
it still is not working. Any sugestions.

 

[Rick Brandt]

I have an accesss form that has fields from several databases on it.
After adding fields from yet another database it no longer lets me
add records. It just beeps at me when I try to edit or add. I've
deleted the work I did but it still is not working. Any sugestions.

Multi-table queries are usually not updateable. Some can be made updateable,
but the more tables you add, the less likely it will be.

Normally you would use a form with subforms or a form with linked popup forms or
a combination of the two.

 

[Guest]

Thanks, I was not aware for the updateability issue in Multi-table queries. I
was editing the SQL language of the queries to add fields because the
standard access procedures where not working. That makes more sense now.

Arob