reversing a switchboard.

[LOUISBUHAGIAR54]

I have a database which I have developed several years ago and which has been servicing my office faithfully for so long. It has a form called 'switchboard' which was the first form that the database enters on opening.

Now I need to change this so that I replace it with a logon form. I was under the impression that I had organised the autoexec macro to introduce 'switchboard' on opening.

Apparently not. Now I have put in frmLogon as the form which autoexec introduces on entry. However form 'switchboard' still comes up behind frmLogon on opening.

When I scrutinised Autoexec macro before I changed it, the form which was opened with the macro was not switchboard but another form.

I am sure that I must have done some other code or some other settings so that 'switchboard' continues to come up on entry.

Can anyone think of what I could have done and advise on how to reverse it please ?


LouisB.

 

[G37Sam]

1) Get rid of all the autoexec related Macro's

2) Go to office button => Current Database => Display form and choose the form you want to load

 

[Knildon]

Louis,
Maybe you're calling that form from the "Startup" menu and that's why you can't find it in an autoexec file.
Look under Tools-->Startup.
It's worth a try.
Don

 

[LOUISBUHAGIAR54]

Both of you are fully correct. When I developed the db originally i did it with Access 2003. Apparently when I crossed over to 2007 either the program changed the settings automatically or I had done it myself.

I did exactly as you suggested. I removed all openform commands form the autoexec macro and put "FrmLogon" as the form to start on startup.

However now when "switchboard" appears after the logon form is filled up, it is smaller than normal and does not full the whole screen. When it is called it is called as Normal not as a dialog form. I hope I am explaining myself correctly.

Again I checked the modal and pop on properties and they are set to no.

any clues on this one ?

LouisB

 

[Knildon]

Louis,
Glad to hear that you are making progress.
I've never used a switchboard so I don't know how it is being called to open. If it's like other forms try adding "DoCmd.Maximize" in the code.
Don