blank records added to Main Table

O

Octavia

There are forms in my Access 2003 db that search for data only, edit selected
data and display (read only) data. The search and edit forms (recently
added) to the db are inserting blank records into the main table with an
autonum as the primary key. Please help with the ALLOWADDITIONS, ALLOWEDITS
and DATAENTRY properties. Conditions: 01. Search form should not add
records but Users must enter data to search; 02. Edit should load selected
record to edit only and not add records; 03. Display loads the selected
record as read only. All conditions function properly except that blank
records are added on CLOSE. BTW: Primary key in main tb is necessary.
Thanks!
 
Top