Results 1 to 1 of 1
  1. #1
    slymn_231 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    1

    Can't add record to sub form

    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.
    Last edited by slymn_231; 11-10-2009 at 07:17 PM. Reason: Provide extra information

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-27-2009, 03:53 PM
  2. removing record from form
    By rsearing in forum Programming
    Replies: 7
    Last Post: 05-14-2009, 10:34 PM
  3. Replies: 9
    Last Post: 03-24-2009, 09:19 PM
  4. Replies: 0
    Last Post: 11-10-2008, 12:32 PM
  5. Form Record Count
    By Texaine in forum Forms
    Replies: 0
    Last Post: 10-19-2006, 09:07 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums