I got a slight problem wher e'm trying to delete a record on a subform using a command button - I'm lost in the VBA of how to acieve this correctly. I have tried almost every combination of domenu and doSQL command to try and remove the records to no avail...
I saw a post recently that mentioned
CODE
Me.frmSub.Form.Recordset.Delete
Me.frmSub.Form.Recordset.MoveNext
Me.frmSub.Form.Recordset.MoveNext
But in my searching I never saw the option for a normal recordset only all the extra options, am I missing a refrence or something?
Thanks a miillion.