load/display form from a form

can you do something like the following code in access

VB Code:

Private Sub Form_Load()
   Dim xFrm As New frmExample
 
 
   xFrm.Show vbModal
 
   'AllowAccess is a property
   If Not xFrm.AllowAccess Then End
End Sub

can something like this be done in MS Access?!?!?!!?
because i can get anything to work the way i want it to. I was hoping that it would work like regular VB...but i guess i'm wishing for to much.

No

xFrm.Show vbModal <<--- the code wiill wait here until the calling form is closed or made invisible.. unless you have code in there which checks the access rights - in which case why bother opening the form, just call the checks before?


Vince