Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009

    Unanswered: insert a record from a form to a subform

    Dear All

    i have 3 forms main form and its subform and another form

    when i choose a record from the form i want that record be inserted to the subform directly so i can chose many records from the form and every time the record that i chose be inserted to the sub form

    any idea to help me

    best regards

  2. #2
    Join Date
    Dec 2004
    Madison, WI
    I haven't a clue what you're asking. Can you be more specific so we can give you a good answer?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Apr 2009
    Dear pkstormy

    Thanks for your reply

    let me explain

    i want to insert many records from a seperated form (items) and these records are automaticaly will be inserted in a sub form (sub_menu)
    thats all

    best regards
    and hope to get ur hepl

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    Sounds like you need an APPEND query and then a little ReQuery action.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts