"No New Data Added" on form

[luzz]

here try this, delete first all records from MainSampleData before running the FORM.

check and view NewSampleData query.

Hi, what is the different between paste error table and the temp table?

 

[arnelgp]

Forget about the error table, must have created it while i was testing.

 

[luzz]

Forget about the error table, must have created it while i was testing.

okay. I realize that the MainSampleData table have 100+ reocrds when my excel sheet only have 33 records.