open form not in tab of ms access

[SantoR]

how to make application such that only a form is opened (not as a tab in access) just like pop up feature of a form. i have only one form in my applcaition

 

[Ranman256]

in a macro, choose OPENFORM
fill in the needed boxes,
AND set WINDOWMODE = dialog

 

[vbaInet]

I'm quite intrigued that you've got just the one form SantoR. No reports at all either?

If you've only got one form then you also want to set the default form in Access Options. That will ensure that your form loads when the db starts. And perhaps it's better to set the Pop Up property in the form itself rather than through code.