So I am trying to use a button click to open the next form (in my form flow), and pass the ID to the next form using openArgs:
docmd.openform "NextForm",,,,,, MainID
docmd.close acform, "CurrentForm", acSaveYes
the second form will not open....i have never run into this problem with a docmd.openform in a sub before. however, this is my first experience using OpenArgs....usually I would pass a value to a hidden text box, but I am trying something different.
The routine runs without error, and the currentform closes just as it should. It's like access is convinced the second form is in fact open, but its not showing up. Also if I even try to show the database objects window, and just click open the form from there.....nothing
please help! thanks Justin