I have a form with a sub-form in datasheet layout.
I'd have a command button on the form which I would like to add a new record to the sub-form. (image attached)
Unfortunately, I can't seem to get it to work with a sub-form, though it does if you try to add records to a form itself.
Any ideas?
[IMG]file:///C:/Stuart/Software%20Engineering/main%20form.jpg[/IMG]
At the moment the code behind the on_click event for the button is as follows...
Forms!Main!IssDef.SetFocus
DoCmd.GoToRecord , , acNewRec
Thanks.