You actually don't need to use VBA at all for this. There is a form event property called On Timer that performs a given event on a specified time interval. This is a great way to do what you are talking about without having to write any code. Here's what you need to do:
1) Create a two step macro that closes your startup form and then opens your next form.
2) Open your startup form in Design View.
3) Open the startup form's Properties windows and goto the Events tab.
4) Set the On Timer property to the name of the macro you just created.
5) Under the On Timer property is a property called Timer Interval. In Timer Interval, set the time interval you wish to use (ie. how long you want your startup form to stay open). NOTE: the Timer Interval counts in milliseconds, so for 5 seconds you need to type in 5000.
This should do it for you. Let me know if this didn't answer your question!
Jamie
[This message has been edited by jstutz (edited 02-11-2000).]