Record wont Save !!!

D

desibasha

Registered User.

Local time

Today, 02:08

Joined

Feb 12, 2004

Messages

27

• May 26, 2004

• #1

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.

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Yesterday, 21:08

Joined

Feb 19, 2002

Messages

47,594

• May 26, 2004

• #2

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?

 

D

desibasha

Registered User.

Local time

Today, 02:08

Joined

Feb 12, 2004

Messages

27

• May 27, 2004

• #3

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????

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Yesterday, 21:08

Joined

Feb 19, 2002

Messages

47,594

• May 28, 2004

• #4

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.