Opening a form just one time on first launch

[drblackard]

Hi all! I am looking for some help in how to get a form to open just once on the first launch of the database. This information is the company information of the one using the software. I have a button that one can click if they want to edit or add this information later. Thanks for your help in advance.

 

[boblarson]

You can use a DLookup to see if the information is already in the table and if it is you can cancel the open of the form.

 

[drblackard]

Thanks Bob Larsen. I do understand the function but I can't quite figure out how to use the Dlookup funtion...can't seem to get the information that I need to open/close the form depending on criteria or finding of information entered into table. Sorry i sound so elementary here but this is a function that I am not familiar with. Can you help me with this function? I have company information that I am looking for:

Company Name
Company Address
Company Phone
Company Email address

I want to use the dlookup to look for the "Company Name" and then if it is there close the form, if it is not there, open the add new company information form.