Using A2003 and A2007.
I have a file that includes a continuous form (FormC) that can be opened from one of several single forms(form1, form2 etc.). The single forms vary only slightly (variations of same product). The single form stays open after it opens the continuous formC. For some operations, (printing being the main one) I want to want to return focus from FormC to a record on the single form with a specific value for one field - (idquote). This is not necessarily the record that was on focus when single form was used to open formC.
I use the following simple code:
If Me.FrmPrev = Me.TSsel Then
Dim idq As Long
idq = Me.IDquoteSel ‘ idquote number on FormC
DoCmd.close ‘closes continuous formC. - Single form1 or 2 or 3 is now active form
DoCmd.GoToControl "idquote"
DoCmd.FindRecord idq
End If
This works great for Form1. But, Forms3 and 2, I get this message:
“Error 2110 Msoft Access cannot move the focus to the control idquote”.
How can it work for one form and not the others? They are almost identical. On form2 itself, I inserted a docmd.GotoControl "IDquote”, DocmdFind etc. button and works fine there.
Driving me up the wall. Any help much much appreciated.