Hello!
Does anyone know how I can get a form to open on startup, if the value in a field in that form is null. I have also posted this topic on the Forms forum, but I wondered whether I could use a piece of VB code to solve this problem.
For example I have a form that should only ever open the very first time a database is opened, which the user must enter a name into a field. This information is then used in other parts of the database.
The next time they open the database, I just want it to show the normal menu screen.
I tried writing an autoexec macro, although I can get the form to open, this is every time the database is opened (and anyway I could do this though the startup options). When I tried putting a condition on the form it all went horribly wrong!
Any thoughts would be much appreciated!
Emma
Does anyone know how I can get a form to open on startup, if the value in a field in that form is null. I have also posted this topic on the Forms forum, but I wondered whether I could use a piece of VB code to solve this problem.
For example I have a form that should only ever open the very first time a database is opened, which the user must enter a name into a field. This information is then used in other parts of the database.
The next time they open the database, I just want it to show the normal menu screen.
I tried writing an autoexec macro, although I can get the form to open, this is every time the database is opened (and anyway I could do this though the startup options). When I tried putting a condition on the form it all went horribly wrong!
Any thoughts would be much appreciated!
Emma
