469,150 Members | 1,995 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,150 developers. It's quick & easy.

Microsoft Access Form : Setting New Record

In Microsoft access 2013 how can I set new record as a default without VBA coding and macro when form opens?
Jul 23 '14 #1
4 1051
twinnyfo
3,653 Expert Mod 2GB
On the Form settings, set the form's Data Entry property to Yes. However, this will "hide" any other records.

Other than that, you can't do it without VBA or a macro (as far as I know).
Jul 23 '14 #2
NeoPa
32,165 Expert Mod 16PB
An alternative is to specify you want data entry only in the code that opens the form - assuming you have any.
Jul 24 '14 #3
I have created parent Form with subform without any coding . So let me know how to write coding to open a form with new record option as default.
Jul 24 '14 #4
NeoPa
32,165 Expert Mod 16PB
Not for a subform, as they aren't opened as such. Certainly not with code. They become open when the main form is opened, but the code would only open the main form.
Jul 25 '14 #5

Post your reply

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

Similar topics

1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.