inserting records via command button

bogglebeats

Registered User.
Local time
Today, 17:17
Joined
Dec 19, 2002
Messages
53
i have made a form called Employee Data which is mainly for calculations of number values. when i open the form, it seems that a record is automatically created. in my other forms, the records start at "0" even though it says record 1 of 1. In the other forms i can press a new record button and the recordset remains to 1 of 1 if it is empty. in this form, i should be able to press a button for new record and that new record should be "1". instead when i press the button for the new record, it jumps to record "2". also, when i scroll through the records, i have to press the < or > buttons twice each to move to the previous or next record. it seems that 2 records are created for each id. (one default and one by user). it's kind of weird so i don't know too much more about it. what is going on??? please help!

ameen
 
Check your forms property. Make sure Data Entry is set to No. Data entry only allows new records to be created
 
data entry is set to 'no'. every time a record is selected, Access creates a new record. so even when a try to delete a record, every other time deletion is attempted then a record is created. any ideas??
 
Last edited:

Users who are viewing this thread

Back
Top Bottom