J
J. Keggerlord
I created a data entry form for the main table of my database. My
recordsource is the table to which I'm trying to add a new record. My Data
settings for the form Properties are:
Recordsource: tblMainTable
Filter: <blank>
Order by: tblMainTable.RecordNumber
Allow Filters: Yes
Allow Edits: No
Allow Deletions: No
Allow Additions: Yes
Data Entry: Yes
Recordset Type: Dynaset
Record Locks: Edited Record
Fetch Defaults: Yes
What's odd is that it seems some people are able to add records while others
are not. I remember something about "pessimistic record locking" from a
class I took many moons ago. Could that have something to do with why the
information I add to the form doesn't show up in the table? Is there a
better way to accomplish what I'm trying to do? Thanks in advance for any
help!
recordsource is the table to which I'm trying to add a new record. My Data
settings for the form Properties are:
Recordsource: tblMainTable
Filter: <blank>
Order by: tblMainTable.RecordNumber
Allow Filters: Yes
Allow Edits: No
Allow Deletions: No
Allow Additions: Yes
Data Entry: Yes
Recordset Type: Dynaset
Record Locks: Edited Record
Fetch Defaults: Yes
What's odd is that it seems some people are able to add records while others
are not. I remember something about "pessimistic record locking" from a
class I took many moons ago. Could that have something to do with why the
information I add to the form doesn't show up in the table? Is there a
better way to accomplish what I'm trying to do? Thanks in advance for any
help!