Go to specific record on another form

[gg80]

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.

[June7]

Instead of multiple forms with slight variations, I would probably have one form with code that manages what is presented on the form depending on some parameter passed to the form.

I've never used GoToControl. I use GetFocus method. But I expect would generate same error.

[gg80]

Without going into detail, multiple forms are optimum in this case. Why am I getting the error on some forms and not the other?

[ItsMe]

I do not believe I have ever used the methods in your sample code before. I do not understand what you are trying to accomplish.

Perhaps some DAO and the bookmark method are appropriate.

[June7]

I don't know why.

Have you considered form/subform arrangement?

If you want to provide db for analysis, follow instructions at bottom of my post.