Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Open a form in Access with a blank record

Apr 10, 2005 4:19AM PDT

I would like to open a form in Access with a blank record. What I mean is I would like the form to open ready to enter a new record not what I have at the monment the last record entered on display when the form opens. Can anyone help.

Discussion is locked

- Collapse -
Re: MS Access: opening a blank form.
Apr 10, 2005 6:30AM PDT

In a macro: OpenForm, use data mode Add.

In VBA (the Visual Basic editor will guide you through the parameters): DoCmd.OpenForm, use data mode acFormAdd.
This comes from my Access 97 help. It might be different in Access 2003 or whatever version you use. As far as I know using docmd isn't recommended anymore. But I'm sure the help voor Openform will be clear enough.

Hope this helps.


Kees

- Collapse -
Will Try
Apr 13, 2005 2:49AM PDT

Thank you will try and let you know