interval between forms by macro in access

[Nilu]

I hv created two form and want after closing 1st form by user then second
form should display and it should remain on the screen for few seconds. Hw i
can do this in Microsoft Acess

 

[Steve Schapel]

Nilu,

Set the Timer Interval property of the second form to the appropriate
number - this is milliseconds, so for example for 3 seconds you would
enter 3000.

Then, make a macro using the Close action, and assign this macro on the
On Timer event property of the form.

Also, make a macro using the OpenForm action, and nominate the second
form to open. Assign this macro on the On Close event property of the
first form.

I think that will then do what you want.