Hi:

I have a form, the data is from two linked table, I find I can't edit or
add new data through this form.

Is that always the case, or may be I need do some settings for this form?

Thank you very much.

James

As you've discovered, not every recordset is editable. Try add/editing
records directly into the query that is the record source of your form, and
you most likely will not be able to.

If you can enter/edit directly in the query, check that the form's Add New,
Delete, and Edit properties are set to "Yes".

If you can NOT enter/edit directly in the query, this is most likely the
result of the set relational integrity and defined joins.
You could change those, or re-design your form. Consider a mainform -
subform layout if the data is related 1-many.
-Ed

"James" <(E-Mail Removed)> wrote in message
news:4E56CCD7-2781-4569-926A-(E-Mail Removed)...
> Hi:
>
> I have a form, the data is from two linked table, I find I can't edit or
> add new data through this form.
>
> Is that always the case, or may be I need do some settings for this form?
>
> Thank you very much.
>
> James

This appears to be a 1 to many relationship and you are trying to use a
query to do edits and adds. Ain't gonna happen. What you need is a form for
the parent table and a subform for the child table.

"James" wrote:

> Hi:
>
> I have a form, the data is from two linked table, I find I can't edit or
> add new data through this form.
>
> Is that always the case, or may be I need do some settings for this form?
>
> Thank you very much.
>
> James