How to UPDATE records using a sub-form

  • Thread starter Thread starter DetRich
  • Start date Start date
D

DetRich

Hello,

I am trying to develop a Computer-Info type of database.
I have a main form that has a Tab control. Each tab has a subform on it.
The main form displays data from the main, or Parent table. Each sub-form of
course has data from a child-table. Tab #1 has hardware config info.

Problem:
Whenever I try to update anyting on a sub-form, I get an error indicating
the update is not allowed. Actually, Access is trying to add a new record.
How do I tell Access that it should be updating an existing record and not
creating a new record? I need Access to do this rather than writing the SQL
code myself. I'm still a novice not that good yet.

TIA,
Rich
 
Hello,

I am trying to develop a Computer-Info type of database.
I have a main form that has a Tab control. Each tab has a subform on it.
The main form displays data from the main, or Parent table. Each sub-form of
course has data from a child-table. Tab #1 has hardware config info.

Problem:
Whenever I try to update anyting on a sub-form, I get an error indicating
the update is not allowed. Actually, Access is trying to add a new record.
How do I tell Access that it should be updating an existing record and not
creating a new record? I need Access to do this rather than writing the SQL
code myself. I'm still a novice not that good yet.

TIA,
Rich
Click to expand...

What is the Control Source of the subform? What are its Master and Child Link
Fields? Is the subform's Data Entry property set to No (it should be)?
 
Back
Top