database form popping up

[groengoen]

I know this is pretty basic, but it is annoying me. Whenever I bring up a certain form in my database, it seems to call up the database form. How can I get rid of this.

 

[RuralGuy]

I'm not sure what you mean by this post. Do 2 forms open? Do you have any code in the "certain" form? Does it happen right away or after you enter or push something?

 

[groengoen]

apologies for not being more specific. I mean that when I go into my switchboard form, which is the startup form, and then go into the main form, after I close the main form, the database window pops up.

 

[RuralGuy]

Instead of going back to the Switchboard? Can you post a stripped down version of the db that demonstrates the problem?

Are you trying to hide Access?

 

[groengoen]

my cut down version of the database does not fit. It is 900Kbytes. I removed everything out of the tables and removed most of the forms, but there it is. What i do basically want to do is hide the database window.

 

[RuralGuy]

Edit the last post and attach the file. Been there, done that!

 

[RuralGuy]

Do you have Compact on Close turned on? Tools>Options>General Tab You could also email me the db at Rural Guy at Wild Blue dot Net without the spaces if you can not get the file < 500KB

 

[ghudson]

apologies for not being more specific. I mean that when I go into my switchboard form, which is the startup form, and then go into the main form, after I close the main form, the database window pops up.

You need to code which form you want opened when the user clicks your button to close the main form. You should hide the database window and also the standard tool bars and menu bars to prevent the user from ever seeing the database window. All of your forms should have a navigation button that they have to click to close each form and you need to code the buttons to open another form as they navigate through your db.

Check this out for some simple tricks... Hide all Access Toolbars and Menubars

 

[groengoen]

I discovered what it was eventually. I had maximized my form and on closing I had the following code put in to do what I thought was "restore" everything down to their original sizes. I took it out and the problem went away.

DoCmd.SelectObject acForm, "PolicyForID", True
DoCmd.Restore


Sorry for being a nuisance

Cheers,

Groengoen

 

[RuralGuy]

Not a nuisance!! That's what these forums are for. Often just asking the right question is all that is required for the OP to find the solution.