Problem with acdialog with form in DS view

Skip Bisconer

Who Me?
Local time
Yesterday, 18:27
Joined
Jan 22, 2008
Messages
285
Is there an issue with using acdialog and opening a form in DS view?
When I run this code the parent form comes right back but none of the controls are enabled. Is there some setting I am missing? I though acdialog was supposed to reign king until I closed the other form.

Any advise is appreciated.

Code:
Private Sub Command40_Click()
'Open tables for maintenance
Select Case Frame41
Case 1
Me.Visible = False
    DoCmd.OpenForm "OpenTableEmployeeRecord", acFormDS, , , , acDialog
Me.Visible = True
Case 2
Me.Visible = False
    DoCmd.OpenForm "OpenTableTerminatedEmployees", acFormDS, , , , acDialog
Me.Visible = True
 
Case 3
Me.Visible = False
     DoCmd.OpenForm "OpenTableTrainingLog", acFormDS, , , , acDialog
Me.Visible = True
 
Case 4
Me.Visible = False
     DoCmd.OpenForm "OpenTableEmployeeRecord", acFormDS, , , , acDialog
Me.Visible = True
 
Case 5
Me.Visible = False
     DoCmd.OpenForm "OpenTableTrainingRequirementsByPosition", acFormDS, , , , acDialog
Me.Visible = True
 
End Select
End Sub
 

Users who are viewing this thread

Back
Top Bottom