Hi all
I have a form which adds comments to an invoice record. The user can add as many comments as they like. I currently have a 'add comments' section at the top which works through some code to add comments to the table. I want to change this to run a subform instead.
I have add 'addcomment' form which I'm using as my subform. When I run the 'addcomments' form it defaults to a new record. I have it set as allow data entry and when it opens it opens up a blank comments section. When I insert this in to my main form, it defaults to the last record I entered, instead of to a new record.
I have set the main form and the subform to both allow additions. I have also added the code DoCmd.GoToRecord , , acNewRec to the On Load property of the subform (I'm trid On Open and On Current as well). None of these appears to work. I have also added a button to the subform to go to the new record, which worls so I'm a little puzzled as to why this isn't working.
Any help or things I haven't tried?
I have a form which adds comments to an invoice record. The user can add as many comments as they like. I currently have a 'add comments' section at the top which works through some code to add comments to the table. I want to change this to run a subform instead.
I have add 'addcomment' form which I'm using as my subform. When I run the 'addcomments' form it defaults to a new record. I have it set as allow data entry and when it opens it opens up a blank comments section. When I insert this in to my main form, it defaults to the last record I entered, instead of to a new record.
I have set the main form and the subform to both allow additions. I have also added the code DoCmd.GoToRecord , , acNewRec to the On Load property of the subform (I'm trid On Open and On Current as well). None of these appears to work. I have also added a button to the subform to go to the new record, which worls so I'm a little puzzled as to why this isn't working.
Any help or things I haven't tried?
