Adding a new record to a subform (datasheet)

[Introfield]

I have a form which contains a subform
Main form shows company details, subform shows history or contact/communication with that company. My client would like to have the blank row (new record) appear at the top of the datasheet subform and not the bottom to speed up data entry.
My alternative solution was to use a "go to new record" macro/module on activating the subform but it doesn't work.
Can you help please?

 

[gusbrunston]

Hi:

Put this in the On Open event of the form:

        DoCmd.GoToRecord , , acNewRec

Ought'a work. Gus Brunston An old PICKer, using Access2000.

 

[Introfield]

Thanks for your quick response. I'm sure I tried this already and had a problem because the new record is to be added to the subform (in datasheet view) and the subform is opened at the same time as the main form.

 

[gusbrunston]

Hello:

Don't put the code in the main form.

Open the sub form by itself. Open the property sheet for the sub form and enter the code. Gus Brunston An old PICKer, using Access2000.