I have Form1 that is built from Query1, Form2 is built off of Query1 also, but is used as a quick or small 'update' form that is called from Form1, you could say that Form2 is a pop-up form called from Form1.
While Form1 is loaded, I use Form2 to update or make changes on certain items. I would like to be able to close Form2, perform a requery on and maintain my position on Form1.
So on the 'OnClose' event of Form2, I tried:
Dim Ttemp As String
Ttemp = Forms![Form1]!FullN
It errors out at:
With "Run-time error '2046' - The command or action 'FindRecord' isn't available now".
If I hover my mouse over Ttemp, the correct value is listed in the intellisense.
Any ideas or other suggestions?