I would like to clear the data displayed in a subform with VBA using a button, similar to when you have the DataEntry property set to NO, and then has to close and open a specific form, to clear it.
In short, the data will be displayed in form until you clear it with a button - (dataentry will be yes, till you press the clear button)
My reason for doing this - when i temporarily close the main form and return later, all data captured are deleted from the subform, and i then have to check what was the last data captured, before continuing with the next lot. This wastes time.
the main form is "StocktakeF"
the subform is called : "Fis_stocktakeSF"
Any suggestions?