Results 1 to 2 of 2
  1. #1
    mrt1069 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Alabama
    Posts
    9

    Duplicating Table/form/reports with new sources

    Hi, I am trying to create a duplicate of a table, form, and report for a secondary use, and I am having trouble getting all of the relationships set up properly.



    Right now I have a Table for purchases, and form to enter data into said table, and a report to display a purchase order.

    I would like to duplicate all of this info and use the same basic format to create a new table for requests for quotations, which would be separate from the purchase order table.

    I can duplicate the table fairly easily and rename it to Request for Quotations, but how do I duplicate the forms and reports and get them to update the Request for Quotations table rather than the original table?

    Thanks,

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    The easiest way to create a copy of a form is to highlight the form in the navigation panel, use Ctrl-C to copy, then Ctrl-V to paste. Access might automatically create a new name for the copy, in which case you will have to rename it manually, or it might ask you for a new name.

    Then open the new form in design view, and in the proprties, change the record source to the Request for Quotations table. Having done that, you will have to go through all the controls making sure they are bound to fields in the new table, and make the required changes. Access cannot do that automatically.

    You will probably need to make some changes to the form's VBA code, if you have any.

    If the two source tables are essentially the same (i.e. same field names) it is not as bad as it might seem.

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

Similar Threads

  1. Universal Form for different sources
    By theperson in forum Access
    Replies: 13
    Last Post: 01-27-2015, 01:22 PM
  2. Replies: 7
    Last Post: 08-22-2014, 05:10 PM
  3. Manipulating Form&Query Sources
    By dinorbaccess in forum Forms
    Replies: 3
    Last Post: 12-30-2010, 11:11 AM
  4. Insert query into table FROM two table sources
    By svcghost in forum Queries
    Replies: 2
    Last Post: 11-05-2010, 09:10 AM
  5. one form two sources - invalid control source msg
    By techexpressinc in forum Forms
    Replies: 1
    Last Post: 05-28-2010, 02:11 PM

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