how to call the the dtabase with 3 tables that only 1 table will be used in recordset

like i have 3 table in my data.mdb, october, november and december table, so in my form i like to use only october in my form how do i call that october so only that october can be used in my field form


thanks

dim rs as Recordset
Set rs = New Recordset
rs.Open "october", cn, adOpenDynamic, adLockOptimistic
    rs.AddNew
    serialtxt.SetFocus

not sure

Hi
Google search for "VB6 Recordset AddNew" came up with a bunch of articles.
Which have you tried and what are you unsure about?
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

Will first but now its ok ^^