migrate form to new tables

I have a task database here (www.dropio.com/tasksdb).  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.
Who is Participating?
clarkscottConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.