Open a form

A

AN

Hi

How to open a form in new record mode, i tried the following code under a
comand button click envent, but it's not working.If i change the "Data Entry
Property" to "Yes", it works but it does not allow to edit other records.

DoCmd.OpenForm "MyForm", , , , , acDialog, "GotoNew"
I am using Access2000

Thanks
 
R

Rob Oldfield

DoCmd.OpenForm "MyForm", acNormal
DoCmd.GoToRecord acDataForm, "MyForm", acNewRec
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access combo box dd click to open another form problem 0
You'll need a new app to open this about link 1
DblClick event doesn't go to new record 2
How do I clear a form? 0
open form maximize 2
limiting number of records in form 1
How to pass multiple Fields to new Form 2
How to pass multiple Fields to another Form? 7

Top