Edit or AddNew in a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top