All my form does is write an empty record whenI click save

[Rene Simons]

Hi,
I have a browse in a form.
I click the insert/add button and the form appears....
I fiil the fields, click submit and .....
No new record in the browse to be seen.
I check the file and all there is, is a primed record with none of the data I entered.
There are no specials, extra's or database connections in the form.
Hope anyone can help.

Thanks
Rene

[Mike Grigsby]

Do you have the "ignore record not being unique" (sorry, I forget the exact prompt) checked? Is the key unique? And the unique ID on the form is the same as the unique key in the table? The key is defined as having a unique, auto-incrementing key with just one field? Just some thoughts. I've seen this before, but can't recall the exact solution, but I think it had something to do with the key usage on the form and the table.

[Rene Simons]

Thanks Mike,

>>>Do you have the "ignore record not being unique" (sorry, I forget the exact prompt) checked?
no

>>>Is the key unique?
yes

>>>And the unique ID on the form is the same as the unique key in the table?
yes
 
>>>The key is defined as having a unique, auto-incrementing key with just one field?
Unique yes, auto-incrementing BINGO!!!!, One field yes

>>>Just some thoughts. I've seen this before, but can't recall the exact solution, but I think it had something to do with the key usage on the form and the table.

You were right on target with the auto-incrementing key .

THANKS FOR YOUR INPUT

RENE