Tabbing through controls appends new record 1

[Ascentient]

When controls are tabbed all the way through a form with bound controls it automatically adds the record to the table.

Is there a way to prevent this? It is placing an invalid record in a table and I would like to prevent this from happening.

Ascent

 

[ormsk]

Try setting the AllowAdditions to false in the form designer on the Data Tab of the Form properties

**********************************
There is more than one way to skin a cat...but who wants a skinned cat?

 

[Ascentient]

I tried that, but when my form loads I get a blank detail section. (bound form)

Ascent

 

[jkl0]

Under Form Properties, set Cycle = Current Record

Then you will need to add a command button to save the record.

 

[Ascentient]

jkl0,
Thank you for the easy fix.

Ascent