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?
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?