Update Data Only

[Guest]

My form links directly to my table - What I need is all data entered into the
form's fields should simply be an original entry or an update to what's
already in that field, what I am getting is a new row is added to my table
each time a value is entered in one of the fields, Is there a way to lock the
table so that there is only one row of data ?

Thanks

 

[Dale Fye]

George,

You can set the forms Allow Additions property (on the data tab of the forms
propery dialog) to False. This will prevent new records from being created
for the underlying table.

HTH
Dale