Hi
Access 2002
Windows XPPro Sp2
From the hours of research I've done today, I seem to be in good company, this is obviously an area of confusion for most of us.
I have a simple subform (i.e. no Record Source with 5 or 6 unbound fields). I am extracting some records using a recordset and want to write that resulting recordset into the subform (and then display it in datasheet view). I tried a number of methods from the posts I've read in order to create new a record(s) in the subform (I need to add many new records in a loop) including the following:-
RunCommand acCmdRecordsGoToNew
DoCmd.GoToRecord , , acNewRec
me.mysubform.form.newrecord
I've carefully set the focus to the subform and subform controls.
I want to avoid the recordset.clone method as I want the user to be able to cancel out or "undo" any changes they've made. That is to say, when they hit a "save" button, I'll permanently write the records back to the table myself .
So far none of the methods I've tried have worked for me and I've tried so many times I've now confused myself as to which did not work and for what reason!!
Sometimes I got the "you can't use this now" error, other times I got syntax problems..... I've been programming various computers for nearly 30 years now and I am just about to give up with VBA / Access hah!
Does anyone have any reliable code that will work (for Access 2002) please to perform this simple operation (I thought!) .
I need to go and open a number of beer cans now.....
Thanks as always
Access 2002
Windows XPPro Sp2
From the hours of research I've done today, I seem to be in good company, this is obviously an area of confusion for most of us.
I have a simple subform (i.e. no Record Source with 5 or 6 unbound fields). I am extracting some records using a recordset and want to write that resulting recordset into the subform (and then display it in datasheet view). I tried a number of methods from the posts I've read in order to create new a record(s) in the subform (I need to add many new records in a loop) including the following:-
RunCommand acCmdRecordsGoToNew
DoCmd.GoToRecord , , acNewRec
me.mysubform.form.newrecord
I've carefully set the focus to the subform and subform controls.
I want to avoid the recordset.clone method as I want the user to be able to cancel out or "undo" any changes they've made. That is to say, when they hit a "save" button, I'll permanently write the records back to the table myself .
So far none of the methods I've tried have worked for me and I've tried so many times I've now confused myself as to which did not work and for what reason!!

Does anyone have any reliable code that will work (for Access 2002) please to perform this simple operation (I thought!) .
I need to go and open a number of beer cans now.....
Thanks as always