Hi all,
Like many of you i have to idiot proof my simple databases for the uninitiated. I currently have a main client form (frmClients) which i load with Allow.Deletions Allow.Edits and Allow.Additions all set as default to False. I then have a series of cmd buttons which toggle the appropriate form state on click etc.
I also have a subform (frmClientFees) on the main form. I have set up the frmClientFees subform to include a delete record cmd button, so for each record in the subform there is a corresponding delete button.
The subform is set by default to Allow.Edits and Allow.Deletions to True but for some reason when i try the delete cmd button i get the "the command or action DeleteRecord is not available" message.
The subform seems to be adopting the mother forms allow specifications, but doesn't change when cmd button is clicked.
Like many of you i have to idiot proof my simple databases for the uninitiated. I currently have a main client form (frmClients) which i load with Allow.Deletions Allow.Edits and Allow.Additions all set as default to False. I then have a series of cmd buttons which toggle the appropriate form state on click etc.
I also have a subform (frmClientFees) on the main form. I have set up the frmClientFees subform to include a delete record cmd button, so for each record in the subform there is a corresponding delete button.
The subform is set by default to Allow.Edits and Allow.Deletions to True but for some reason when i try the delete cmd button i get the "the command or action DeleteRecord is not available" message.
The subform seems to be adopting the mother forms allow specifications, but doesn't change when cmd button is clicked.