Joy Gomez
asked on
Get currentrecord of subform
I am using MS Access
1. I have a main form (MainForm).
2. I have a sub form (SubForm).
3. From the SubForm I open another form Form2.
4. I would like to display the currentrecord in Form2 in a textbox so I can use it to GoToRecord in the SubForm.
1. I have a main form (MainForm).
2. I have a sub form (SubForm).
3. From the SubForm I open another form Form2.
4. I would like to display the currentrecord in Form2 in a textbox so I can use it to GoToRecord in the SubForm.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
okay i got it to work... this was a good way to have done this... never knew... thanks much.
ASKER
But now how do I return back to the form that i just open on which i had this code? I am trying to close that form, and it does not.
ASKER
Set sf = Forms![F_Maint_Check_Main]
Dim value As Integer
value = sf.CurrentRecord.value
Hi Fabrice,
I am getting an invalid qualifier error for "CurrentRecord".