Table not record set

**Cran29** · 03-06-2013, 03:22 PM

I have just completed a simple Data Base with a sub form for entering records. When i try and enter Data it shows an error saying key in employee table not record set. How do i fix this please.

**orange** · 03-06-2013, 03:31 PM

You haven't told us much about your database and tables. If you have a subform, the implication is you have a Form and on that form you have a subform.
In classic Access Form/SubForm, set up to deal with a 1 to Many relationship, the 1 side of the relationship is handled in the Form, and the Many side is handled by the SubForm.

Code:

                (1)         (Many)
analogy is Parent--->Child

If you are trying to add a new record in the subform, that is not part of the record on the Main form, Access will give an error.

You can't have a Child record, until there is a Parent record

**Cran29** · 03-07-2013, 02:51 PM

Please find attached a copy of the Dat base. I cannot get it to save records using the Sub form. Can you see where i am going wrong baffled

Table not record set

Thread Tools

Table not record set

Similar Threads

select record on multi item form and add that data as a new record in another table

Form entry replacing table record instead of adding new record

Using VBA to get data from a parent table record to a child table record (address)

DataMacro - Creating a record in a table based on 'FOR EACH RECORD' command.

query get name of data field in one table to match with a record in other table

Posting Permissions