Form not allowing linked tables to be updated

[Raystorm]

Hi All, I've got a form that uses a query to the tables in my database as it's record source, and I've got a problem. Basically, when I'm entering a new record, I can enter data into fields from all of the tables with no problems. However, if I go back and edit an existing record, then Access won't allow me to insert any record into the linked tables, giving me the error 'You can't go to the specified record' when I try to move to another record. If there is already data in the table for that record, then I can add or edit data just fine, it's only if I'm trying to add new data to record that doesn't already have any data in that table.

I hope that what I've said above makes sense, and that someone can help me with what the problem is!

 

[missinglinq]

I'm afraid it really doesn't make sense; you might want to reread it and regroup!

Basically, when I'm entering a new record, I can enter data into fields from all of the tables with no problems... If there is already data in the table for that record, then I can add or edit data just fine, it's only if I'm trying to add new data to record that doesn't already have any data in that table.

The first bolded line says you have no problem adding a new record, the second line says that you do have problems adding a new record! After all, a "record that doesn't already have any data in that table" is a new record!

Linq

 

[Raystorm]

OK, sorry for any confusion! OK, when I go to an existing record, I can't enter any data into fields that are in a linked table. I get the error message that I mentioned in the first post, and when I close the form, I get the error message 'You cannot add or change a record because a related record is required in table 'Asset''. There already is a record in the Asset table, but I want to add data to a table that is linked to this table.

I'm trying to explain this as best I can, sorry!