why my dataentry form doesn't work???

[Mayo123]

I have a form that is linked to a query. The query is created based on the tables which are linked to SQL server. I have set the form’s data entry property to true. But somehow, when the form opens, it is still filled with the data. I have tried: Docmd.openform “formName”,,,, acformAdd, and it failed too.
How can I make the form open – just BLANK…

Thank you in advance for your help!

 

[bubba100]

Have you tried-- Docmd.GoToRecord acForm, "formname", acNewRec

 

[Mayo123]

I tried your code(has to open the form first). I got a msg saying Can't go to the specific record..

 

[SeeThru]

Sounds like the table or query the form is bound to does not allow additions - there are quite a number of reasons for this, including links, subqueries, etc

 

[SeeThru]

Check that you can add a new record to the underlying table/query. If you can't, that is the problem. If you can, need to start checking the form settings.

 

[Mayo123]

Thanks for pointing me to the right direction.
Happy holidays to you all...