Hello,
I am nearlly there with a reconciliation database.
I have a parent form with 2 subforms on, each has various fields and showing all Non POSTED records. One field is a [MATCHED] tick box which I intend to tick when I reconcile the transaction. Once I have ticked a load of them I'd like a button, preferably on the parent form which when clicked updates the tick box [POSTED] for all records in both subforms. This then ensures these transactions are excluded when I refresh the form!
There must be a bit of code I can use to say iif([MATCHED]=yes,update[POSTED] to yes? A bit rusty but if you tell me what code to attach to this button I would be so very grateful
Thank you
I am nearlly there with a reconciliation database.
I have a parent form with 2 subforms on, each has various fields and showing all Non POSTED records. One field is a [MATCHED] tick box which I intend to tick when I reconcile the transaction. Once I have ticked a load of them I'd like a button, preferably on the parent form which when clicked updates the tick box [POSTED] for all records in both subforms. This then ensures these transactions are excluded when I refresh the form!
There must be a bit of code I can use to say iif([MATCHED]=yes,update[POSTED] to yes? A bit rusty but if you tell me what code to attach to this button I would be so very grateful
Thank you
