Entering New Record In A Form (Access 2003)

C

Chai

I have a command button in a form which a user clicks on to enter a new record.
I'd like to restrict a user from entering a new record by clicking in a cell
on a blank line. How do I go about doing this? Thanks.

Chai
 
C

Col

Set the AllowAdditions value on the form to false.
On the click event, set it to true and make the addition
Reset it to false on Afterupdate for the record.
Regards
Col
 
C

Chai

Thanks!

Col said:
Set the AllowAdditions value on the form to false.
On the click event, set it to true and make the addition
Reset it to false on Afterupdate for the record.
Regards
Col
Click to expand...
 
Top