Intro start up form

[MSUKevin]

I have hit a brick wall with this one so maybe some of you could help out...

I have a form entitled, "Database Introductory" Form. The purpose of this form is to gather information on the initial start up of the database. This info is data that will be used through out the rest of the database but only needs input once. i.e. Sales tax rate, business address, org name, etc...

What I want to do is have the form be the start up form the first time the database is opened... but never again. After the initial start up I want the start up form to be my switchboard from then on out.

I have seen this done in the orders entry database and I tried to copy the code but I was unsuccessful. If anyone has any ideas I would really appreciate it.

Thanks in advance...
Kevin

 

[DES]

I assume that all the data you are collecting is being saved in a table someplace such as tbl Defaults.

So add one more field to this table which will be a number.

On the form where you are collecting this data put this field with visible = false

On the After update of the last field on this form which is visible have it set the value of the new hidden field to 1.

On the OnClose event for this form have it open the switchboard.

Go back and set you startup form back to the switchboard.

Go to design view of your switchboard and hide a text box whose data source does a dlookup on the tbl Defaults on the field you just added. If the defaults form has been filled in it should equal 1 now.

So on the OnOpen event of the switchboard do an if statement to find out if the hidden text box = 1.

If it does close the switchboard and open the defaults form.

Once the defaults form has been filled in it will never open again.