Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013
    Posts
    2

    Question Unanswered: Copy records from form and those marked with checkbox in subform to table with button

    Hello,

    I am currently working on a form in a database. This form is used to unite sets of values from separate tables into another table. For that I have created a Form with a Subform. The Form has several comboboxes, which let me select data from one table and the Subform holds the data from the second table. The subform is in datasheet view and has a checkbox to each record, so several records can be selected. Basically what I want to do is to use a button to select all the values selected in the Form and unite them with each value selected in the subform.
    Something like this:

    Table1
    --------
    Name | John
    Surname | Price
    __________

    Table2
    --------
    Check | Order | OrderType
    V | Car | Rental
    V | Bike | Purchase

    And when I use the button I want it to come out to Table3 like this:
    Name | Surname | Order | OrderType
    ------------------------------------
    John | Price | Car | Rental
    John | Price | Car | Purchase


    Is it possible to do something like that?
    The hardest part for me seems to be the selection of records checked with a checkbox in the subform and uniting the selection with the selection from the form.

    Any help would be very helpful
    Thank You.
    Last edited by Precigus; 07-05-13 at 06:49.

  2. #2
    Join Date
    Jul 2013
    Posts
    2
    SOLVED
    Sadly, noone helped

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
  •