Access 2007 - Adding Data to Form

V

Victoria@DIG

I've created a very simple form based on 2 related tables. When I try to add
data it tells me "This Recordset Is Not Updateable."

Form includes the following fields:

Employee ID: from Table 1
First Name: from Table 2
Last Name: from Table 2
Meeting date: from Table 1

Relation: Employee ID from Table 1 = Employee ID from Table 2

Trying to add data to Meeting Date field. Field property includes:
Data/Enabled = Yes
Data/Locked = No

Form Property:
Recordsource =
SELECT [Coffee Friday].*, [Master List - New].[First Name], [Master List -
New].[Last Name]
FROM [Master List - New] INNER JOIN [Coffee Friday] ON [Master List -
New].[Employee ID] = [Coffee Friday].[Employee ID];

Recordset type = Dynaset
Data Entry = No
Record Locks = No Locks

What am I doing wrong?
 
M

Mark A. Sam

Check the [Employee ID] field in table two that it allow duplicates in the
Indexed propety.
 
V

Victoria@DIG

thanks! When creating Table 2 I had completely forgot to set the Index. I
changed it to Yes, no duplicates which agrees with the same field in Table 1.
Now it works.

Mark A. Sam said:
Check the [Employee ID] field in table two that it allow duplicates in the
Indexed propety.


Victoria@DIG said:
I've created a very simple form based on 2 related tables. When I try to
add
data it tells me "This Recordset Is Not Updateable."

Form includes the following fields:

Employee ID: from Table 1
First Name: from Table 2
Last Name: from Table 2
Meeting date: from Table 1

Relation: Employee ID from Table 1 = Employee ID from Table 2

Trying to add data to Meeting Date field. Field property includes:
Data/Enabled = Yes
Data/Locked = No

Form Property:
Recordsource =
SELECT [Coffee Friday].*, [Master List - New].[First Name], [Master List -
New].[Last Name]
FROM [Master List - New] INNER JOIN [Coffee Friday] ON [Master List -
New].[Employee ID] = [Coffee Friday].[Employee ID];

Recordset type = Dynaset
Data Entry = No
Record Locks = No Locks

What am I doing wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top