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.
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