Operation not supported error on form, how to fix?

[ChrisHannah]

hello

i'm getting an "operation not supported for this type of object" error when Pressing the Save Button on a form (this doesn't stop the save function)

This form has a query behind it that limits the list to a selection and that saves data to two tables tables.

i only get the error when updating the two fields from the second table.

i'm assuming that the button needs code that writes it to two tables and not just one (the button was created with the auto "save record" function).

or perhaps i need to re-strucutre my query/or data so this does not happen?
I have opened the query directly and updated the same values and do not recieve the error message so i do think that this is based on the button

 

[sneuberg]

Usually it's best to stick to one table per form and put related tables in subforms. Could you upload your database? Maybe we can make some suggestions.

 

[ChrisHannah]

hello

thanks for the response, i think it was a creation thing...

when i created a new form automatically it did not happen so i sumise that it was because the data used to be held in the one table but it was then moved and the links updated but something was still wrong, i have re-created the form and it has no errors (and it looks better than it ever did so bonus all round)