Trouble with navigation

[John Phelan-Cummings]

Form: Main Menu

From the Main Menu you open up the main form, “Program_services”
(unbound) which serves various purposes aside from the fact that it has
a single unbound, first, subform, “frmMain” with two option buttons.

Button #1 opens a Calendar GRID option, which is on the, “frmMain” form;
again is unbound.

Button #2 opens a Registration option, which contains a, second,
subform, “frmStatus” which is bound (tblStatus table)
The code behind the “frmStatus” subform includes the following which
works but only when I use it as the first subform to the, “frmMain” form
as a main, popup, form:

Private Sub Form_AfterUpdate()
RequeryAllCtls
*Forms!frmMain.DrawGrid (The, DrawGrid is located on the first
subform, “frmMain”, and not on the “frmStatus”.)
End Sub

Also, the frmStatus form also contains 4 synchronized combo boxes; all
four boxes synch together correctly as designed.
Problem:

However, once I synchronize all four combo boxes to call up information
to include in the current record, I try to navigate to another record.
When I try to use the navigation button to move from record to record,
when the “frmMain” form is used as the first sub form to,
“Program_Services” (main form), I get the following error pointing to
code behind the form, “frmStatus”:

*Run-time error '2450':

Microsoft Office Access can't find the form 'frmMain' referred to in a
macro expression or Visual Basic code.

My thinking was that frmMain cannot be found until the main form
“program_services” was found. I tried the follow combinations; nothing
works:

Forms![program_services].frmMain.DrawGrid
Forms![program_services]![frmMain].DrawGrid
Forms!program_services!frmMain.DrawGrid
Forms!program_services!frmMain.DrawGrid
Forms!program_services.frmMain.DrawGrid

John
*** Sent via Developersdex http://www.developersdex.com ***

[MacDermott]

When you need to post the same question to several groups (not often
necessary, as most of the same people lurk in several groups), please put
the names of all the groups into the same post, instead of posting to each
group individually.
That way, everybody will see all answers, as well. People won't be
answering questions that someone else has already addressed. And you won't
have to go hunting in the other groups you posted to, looking for the
answers I've posted for you...

"John Phelan-Cummings" <jp*********@hotmail.com> wrote in message
news:Xy**************@news.uswest.net...

Form: Main Menu

From the Main Menu you open up the main form, "Program_services"
(unbound) which serves various purposes aside from the fact that it has
a single unbound, first, subform, "frmMain" with two option buttons.

Button #1 opens a Calendar GRID option, which is on the, "frmMain" form;
again is unbound.

Button #2 opens a Registration option, which contains a, second,
subform, "frmStatus" which is bound (tblStatus table)
The code behind the "frmStatus" subform includes the following which
works but only when I use it as the first subform to the, "frmMain" form
as a main, popup, form:

Private Sub Form_AfterUpdate()
RequeryAllCtls
*Forms!frmMain.DrawGrid (The, DrawGrid is located on the first
subform, "frmMain", and not on the "frmStatus".)
End Sub

Also, the frmStatus form also contains 4 synchronized combo boxes; all
four boxes synch together correctly as designed.
Problem:

However, once I synchronize all four combo boxes to call up information
to include in the current record, I try to navigate to another record.
When I try to use the navigation button to move from record to record,
when the "frmMain" form is used as the first sub form to,
"Program_Services" (main form), I get the following error pointing to
code behind the form, "frmStatus":

*Run-time error '2450':

Microsoft Office Access can't find the form 'frmMain' referred to in a
macro expression or Visual Basic code.

My thinking was that frmMain cannot be found until the main form
"program_services" was found. I tried the follow combinations; nothing
works:

Forms![program_services].frmMain.DrawGrid
Forms![program_services]![frmMain].DrawGrid
Forms!program_services!frmMain.DrawGrid
Forms!program_services!frmMain.DrawGrid
Forms!program_services.frmMain.DrawGrid

John
*** Sent via Developersdex http://www.developersdex.com ***