Data entry form acting funny

[jlitondo]

I have a simple form with with text and combo boxes that are used to enter data into tables but the first record of each entry is being chopped off such that if I enter 3 records, I only get 2.Any suggestions anyone???

 

[Guest_imported]

time for 20 questions<br>is one of the records in an unbound control? does each field have a source? Is this data being entered into more than one table? Which record is not getting to the table the first record or the last. did you create the form or was it done by the wizard? does the table have a KEY index.<br>not quite 20 but food for thought

 

[jlitondo]

Thanks glo4 for the food for thought.I just solved this problem.What was happenning on the data entry form is this.Since it was being opened by an 'Open Form' command button on another form, I used a macro in this button's on click event procedure to make settings on the data entry form.The problem: The Open Form action of the macro had its Data Mode set to Edit instead of Add which then opened the form for edit and set the record pointer to the very first record on the data entry form's underlying record source table, thus wiping out every first record entered by the data entry form.