Subform Add New Record

[RachelK]

Hi,

I have a main from and a sub form I would like to add a new record to the subform as soon as I tab into it any idea's ?


Cheers Rachel.

 

[lupins46]

Use the On Enter event procedure for the subform CONTROL (not the subform) and just put:

DoCmd.GoToRecord , , acNewRec

Note this will do what you said - go to a new record when you TAB into the subform. If you CLICK into the subform, the clicked position will override the on Enter statement.

 

[RachelK]

Thank you so much it worked !!

 

[RachelK]

Still having problems with this one. as it's on the onEnter event it will not allow me to Edit an exsisting field any idea's how I can have it land on the last record to add but I may want to edit exsisting records.

 

[PHV]

Don't you have the navigations buttons in this subform ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ambermetal]

A similar problem i have on this subform thing.
But in my case i want te subform to move to the next record as soon as i save anything on the main form. Any idea on how to do that?
Many thanks in advance




Ambermetal the stupid intern...