Record wont Save !!!

[desibasha]

I have a form in which you can enter information in different fields.

When you are done and press tab thru them all. it wont save the record. You can try adding a form but you cant. The buttons are not grayed out. You can click them but there is no effect.

What can I do to fix this?

The records are not saving in the table.

There is a query behind this form.

 

[Pat Hartman]

Are you sure you can update with this query? Open the query directly and try to modify data and then try to add a record. What happens?

 

[desibasha]

i get the following error when i try to manully add to the query

"cannot add record(s), join key of table "publisher_contacts" NOT in recordset

so what does that mean? how can i fix it?

is there a relationship missing????

 

[Pat Hartman]

When you join tables in a query, the linking field from the many-side table must be included if you want to be able to add rows to the many-side table. You either have the one-side field or neither field in your query.