Subform question

[Jeffreyb723]

:banghead: I've tried this so many ways and each time I get almost where I need to be.

Right now I have a bound subform that lists all of the relationships from my unbound txtJobNum control and I can add and delete lines from the table directly on the subform.

What I really need is to NOT update the table unless I click on my save command button.

If anyone could point me to an example or if it's not too difficult show me how to achieve this, I would be ecstatic.

 

[CJ_London]

The (subform) table will automatically be updated when you leave the current record of your subform unless you put some code in the before update event to cancel it.

The subform is showing what is in the table so when you leave the current record, you either update or you don't, you can't leave it there to be updated at later time other than as below.

The only way round this is to have a temporary table or recordset to hold the data and base your subform on that. Then when you click your save command button (I presume it is on your main form) you have some vba code to update the 'proper' table.

 

[Jeffreyb723]

Thank you so much, now that you have mentioned that, a temporary table should serve my needs perfectly.