Originally Posted by
ShaunG
...just making sure i dont build the database and end up with awhole lot of errors...
That's why you test as you go...and why you make regular backup copies of your file! If you really scrooch the pooch, you can always go back to your last 'good' copy.
Originally Posted by
ShaunG
...code ive seen to open forms is generally a little bigger...
That depends on what you need to do when you open a file...whether you need to be able to add Records, edit Records...whether you want the Form to open in Datasheet View (even if its Default View is Datasheet View, if you're opening it thru code, you have to specify this) whether you need to go to a particular Record, when opening the Form, and so forth.
A login Form probably requires none of this, but simply needs to be opened, hence
DoCmd.OpenForm "LoginForm"
is probably all that is needed.
Welcome to AFN!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007