Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

DoCmd Open Form question, HELP!

Hello, I have two forms with the field [CallNumber] in them.  When I close frmOne and open frmTwo I want to copy the contents of frmOne.[CallNumber] to frmTwo.[CallNumber].  This isn't a filter because this frmTwo will not have any call number entered in that field.

Can anyone please help me how to do this?
1 Solution
Use the Openargs parameter to pass the value from form1 to form2.

docmd.OpenForm "frmTwo",,,,,,me.callnumber

Then the form currentevent of form2 you use this value

me.Callnumber = me.openargs
BevosAuthor Commented:
Awesome! I had missed the current event part :) you taught me a really nice thing again peter thank you!

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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