prevent saving until a button is clicked.

[Guest]

Hello,
I have a combo box in a form with the project list. When you select one
project, the project information is shown. And then if you click on the
'create' button, it launches a subform called MWRsubform and it is a data
entry form.

I have set it up so that when the 'create' button is clicked, some of the
project information such as description, manager and etc, is carried to the
subform and autopopulate some of the fields in the MWRsubform.

The problem is that when the create button is hit and values are carried
over and the subform is auto populated, the record is immediately saved in
the table, and it is saved once again when I click the 'save' button - so
there is a duplicate record in the table, which I don't want. is there a way
to fix this?

thanks is advance!

 

[Guest]

Speaking strictly for myself, when I want/need that level of control, I use
an unbound form, and do an ADO write when the "ADD RECORD" button is clicked
after all the data ihas been entered on the form.