A kinda easy database question

[Leeper77]

I have a question. I have 5 tables in a database how do i access them without using 5 differant data controls like i have check boxes and if that is checked then i want it to open that table so i can write to that table? if anyone can help me that would be great

You mean change the RecourdSource?

Data1.RecordSource = "Employees"
Data1.Refresh

[ttingen]

Dim sTableName As String

Select Case CheckBoxArray
    Case CheckBoxArray(0)
        sTableName = "First_Table"
    Case CheckBoxArray(1)
        sTableName = "Second_Table"
    Case CheckBoxArray(2)
        sTableName = "Third_Table"
    'and so on
End Select

'Then use the table name in you SQL statement
'to insert records into that table

[Leeper77]

yes that is exactly what i want now whats the code i saw some but im not sure exactly with sql

[parksie]

You mean like this:

rst.RecordSource = "TableName"

rst.AddNew
rst.Fields("Field1").Value = "xxx"
rst.Fields("OtherField").Value = 5
rst.Update