By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,949 Members | 2,085 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,949 IT Pros & Developers. It's quick & easy.

Stop tables automatically generating a row

P: 28

I have just learnt how to use subforms (in datasheet view) and was wondering if there was a way to prevent Access from automatically generating another row when text is entered into the last cell. Ideally I'd like for it to hold off until the "new" button is pressed.

MS Access 2002.

Oct 8 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,072
For this the "Allow additions" property can be set to "No".
(See the subform's data tab of the properties)
With your button you can set this property back to "Yes" when needed.

Clear ?

Oct 8 '07 #2

P: 28
Thankyou Nic,

All clear.
Oct 10 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.