Long Thread, sorry

[badgers]

First thank you to Martin Liss for all the help and to the other who have replied to my other threads.
I am using mdi child forms. each is a copy of the original.
I have a database with a formatted table.
on each creation of a new child form I create a new table. This new child form should point to the new table. I am using a data control Data1 and a DBGrid control.
Each table/form represents an electrical panel schedule.
My problem is that each mdi form is pointing to the original data table.
any input will be appreciated.

Private Sub LoadNewDoc()
    'table2 is a template table. each child form should point
    'to a new table with a name=to the caption of the child form
    Dim frmD As frmDocument
    Dim StrTemp As String 'name of panel
    Set frmD = New frmDocument 'create a child form based on the model
    StrTemp = InputBox("enter Panel Name", "Panel Name?") 'Get name for this panel
    frmD.Caption = StrTemp 'set child window caption to the panel name
    Call CopyTable("c:\test\db1.mdb", "table2", StrTemp) 'copy table 2 to the name of the panel
    frmD.Data1.RecordSource = StrTemp 'try to get the new mdi form to point to the new table
    frmD.Show 'show the user what they've won!
End Sub

how can I get this to work if the panel name has a space in it?
thank you for your time and have a good day

[kleve]

If I read what you've got right, you're trying to get at a table with a space in it's name?

To do this, you need to wrap a [ and a ] around the table names. This works for SQL Server 7, I'm not sure about access or SQL 6.5