Saving Edited/Deleted Information on Subforms (forms)

[soorags]

I have created 2 forms called frmNz2 and frmNz3. I would like to be able to press a command button that would save the editted/deleted information on both forms (in the subforms). How can I create them? Have a look at the attachment, the buttons are created but I don't know how to get them to work.

 

[Epic]

the records are saved but as per your post frmNz2 has a subform frmSearchResults and record source is :

SELECT * FROM query2 WHERE 1=1;
1 = 1 always.

you are also using a query on a single table then use another query to query the previous query to fill your subform... won't be easyer to just use the table directy in your subform Data Source? is there a reason of snapshot record set?


Not sure what you are trying to achieve but anyway you have to requery the subform on the frmNz3 and this would do it:

under your button on click event:
Forms![frmNz3]![SearchResults].Form.Requery