Lynn- You can see that the Current event is changing the form's caption (Me.Caption). What else do you have in your Startup properties? Is this the Startup form, or is it something else? Do you have an AutoExec macro? Something is selecting the database window and then minimizing it. The code I posted earlier is from one of the database templates available on office.microsoft.com that uses a modified version of what the Switchboard Manager builds.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Lynn > Sent: Sunday, August 07, 2005 10:44 AM > To: [email protected] > Subject: [ms_access] Re: Switchboard Question > > > Hi John: > > I don't see the code you showed me. Here's what I have in On Current > and On Open. This is just what the Wizard gave me, I'm guessing.: > > Private Sub Form_Open(Cancel As Integer) > ' Minimize the database window and initialize the form. > > ' Move to the switchboard page that is marked as the default. > Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' " > Me.FilterOn = True > > End Sub > > Private Sub Form_Current() > ' Update the caption and fill in the list of options. > > Me.Caption = Nz(Me![ItemText], "") > FillOptions > > End Sub > __________________________________ > > I went ahead and changed the name back to Main Switchboard from Main > Menu, but it's still not working. What do I need to do to fix it? > > Thanks again, > > L. > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Lynn- > > > > You'll find there's code in the Current event of the Switchboard > form that > > is setting the form's caption. There's also this code in the Open > event: > > > > ' Minimize the database window. > > DoCmd.SelectObject acForm, "Switchboard", True > > DoCmd.Minimize > > > > The SelectObject unhides the database window and the following > command > > minimizes it. The unhide effectively undoes your Startup option. > > > > John Viescas, author > > "Building Microsoft Access Applications" > > "Microsoft Office Access 2003 Inside Out" > > "Running Microsoft Access 2000" > > "SQL Queries for Mere Mortals" > > http://www.viescas.com/ > > > > > -----Original Message----- > > > From: [email protected] > > > [mailto:[EMAIL PROTECTED] On Behalf Of Lynn > > > Sent: Sunday, August 07, 2005 8:35 AM > > > To: [email protected] > > > Subject: [ms_access] Switchboard Question > > > > > > > > > Another question I have: > > > > > > I changed the "Caption" on the Form Property on the Main > Switchboard > > > form to read: > > > Main Menu > > > > > > It still says Main Switchboard, regardless of what I put in > Caption. > > > > > > Why? And how can I change this readout? > > > > > > Thanks in advance, > > > Lynn Bryant > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor > > > --------------------~--> > > > <font face=arial size=-1><a > > > href="http://us.ard.yahoo.com/SIG=12htf6s9p/M=362335.6886445.7 > > > 839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123428874 > > > /A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/to > > > pics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http: > > > //groups.yahoo.com/">In low income neighborhoods, 84% do not > > > own computers. At Network for Good, help bridge the Digital > > > Divide!</a>.</font> > > > -------------------------------------------------------------- > > > ------~-> > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> > <font face=arial size=-1><a > href="http://us.ard.yahoo.com/SIG=12ht1efct/M=362131.6882499.7 > 825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123436726 > /A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org > ">Get Bzzzy! (real tools to help you find a job) Welcome to > the Sweet Life - brought to you by One Economy</a>.</font> > -------------------------------------------------------------- > ------~-> > > > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hp0cvtd/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123438454/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
