S
Simon
I have a table containing client records. I have been
adding to this as I change and develop my database. I
have a select query based on the table and a form using
the query. I have no problem with the older records, but
when I run the query on new records they can not be
edited in the query. They can be edited directly in the
table (or in the form based on the table) so why should
the query change anything?
Some of the records in the table are linked to each
other. All records have a unique Autonumber field to
identify them. If linked, this number appears in a field
of the linked record. If I create a new record and link
it to an old record then the new record can be edited in
the select query. But a new rocord linked to a new
record cannot be.
This used to work OK - with all records being edited in
the table or in the query. Can anyone help with what I
have changed to make this no longer work properly?
adding to this as I change and develop my database. I
have a select query based on the table and a form using
the query. I have no problem with the older records, but
when I run the query on new records they can not be
edited in the query. They can be edited directly in the
table (or in the form based on the table) so why should
the query change anything?
Some of the records in the table are linked to each
other. All records have a unique Autonumber field to
identify them. If linked, this number appears in a field
of the linked record. If I create a new record and link
it to an old record then the new record can be edited in
the select query. But a new rocord linked to a new
record cannot be.
This used to work OK - with all records being edited in
the table or in the query. Can anyone help with what I
have changed to make this no longer work properly?