unbound forms...i think

[ArcherSteve]

Hey, it's me again. I found something else that i just can't figure out how to do.

When my database opens, I want a form to pop up (i dunno if it should be unbound or not) and ask me for some information. Specifically, i want it to ask "Tournament Name?" and I will enter the tournament name. It will then store this information somewhere and somehow. Then, I want to be able to display that information as a heading on a report. Is it possible? If so how?

 

[WayneRyan]

Archer,

You can use Tools --> Startup to specify a form to open.

After the form gets the info you need, you can open your
main form (or switchboard) by:

DoCmd.OpenForm "YourMainForm"

Then, you can "hide" your form and refer to the info entered by:

Forms![YourOpeningForm]![SomeField]

You could also save the info in a global variable, but you will
need code and/or functions to retrieve it for forms/queries.

Wayne

 

[ArcherSteve]

That works but everytime I close the database, the information in the form is reset. Is there anyway i can have it saved and still work the same way?

 

[WayneRyan]

Archer,

If you want to retain info after the DB closes, then you will
have to store it in a table. Make a new table and bind it
to the startup form.

You can take away the navigation bars, set AllowAdditions to
False, etc.

Or, use default values for them.

Wayne