[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

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.
1 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now