Get Table window in front of form

[QuietRiot]

I have to option to view/edit a table on my form. HOw can i get that window in front of the form window. right now you have to exit the form in order to edit it.

Thanks,
QR

    Private Sub EditButton_Click()
    Dim TableName As String
    
'err check if combobox is empty
    If Len(Tablebox.Value & vbNullString) < 1 Then
        MsgBox "You need to select a table to edit!"
        Exit Sub
    Else
     TableName = Tablebox.Value
     DoCmd.OpenTable TableName, acViewNormal
     DoCmd.Close acForm, "MainMenu", acSaveNo
    End If
    
End Sub

 

[boblarson]

You shouldn't really be letting users into the table directly. Make a form based on a query of the table and then you can manipulate to your heart's content, because forms give you more control.