Re: Trouble with navigation

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" <jphelan1242@xxxxxxxxxxx> wrote in message
news:Xyb9f.73$5u.6600@xxxxxxxxxxxxxxxxxx
>
> 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 ***


.

Quantcast