Creating a new record in a subform

[jwalz]

Is there any way programatically to create a new record in a datasheet view sub form? I am trying to create revisions/additions to the detail items in my purchase order form, but can't figure out the correct code to make it happen.

Thanks,
Janet

 

[jimb0ne]

this is very simple. from code do the following.

dim rs as dao.recordset

set rs = subformcontrol.form.recordset

with rs
.addnew
!field1 = whatever
!field2 = whatever
etc.
end with

set rs = nothing


that should be basically all you need to do. Of course you will need to change "subformcontrol" to the name of the subformcontrol on your main form, and you will need to change the field names and values assigned to them.

Let me know how this works.

 

[jwalz]

That did the trick. Although I added a .Update to display the information that I preloaded into the fields.

Thanks so much for your excellent and speedy help.

Janet