Microsoft Access Form : Setting New Record

[ESAKKI109]

In Microsoft access 2013 how can I set new record as a default without VBA coding and macro when form opens?

[twinnyfo]

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).

[NeoPa]

An alternative is to specify you want data entry only in the code that opens the form - assuming you have any.

[ESAKKI109]

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.

[NeoPa]

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.