migrate form to new tables

Posted on 2008-11-04
Last Modified: 2013-11-29
I have a task database here (  I need to make it work with the new tables according to sb9's instructions found in the same location.  It should be a fairly easy thing to change from the looks of his instructions but I would like some assistance if possible in getting the form as fully functioning as possible.  Any assistance is greatly appreciated.
Question by:verpit
    1 Comment
    LVL 20

    Accepted Solution

    You can change a form's recordsource 'on the fly', provided the 'new' recordsource has the same fields as the 'old' recordsource.

    On open event:

    me.recordsource = "yourNewRecordsource"

    PS.  If it doesn't work on open - try on load - I'm not in front of my PC right now and I forget which event works.

    Scott C

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now