new record

[golan]

hello, i have form with 2 comobox in click event the data be fed to
DAO.Recordset then to a table. after that we finish to enter the data i want
that command button
will change the check box to true and to add a new record.
the cursor need to be in the new rew(record).
thanks ,

 

[Erez Mor]

mar golan hayakar

use the After_Update event of the combobox to do the following
Chkbox=True
me.recordSet.AddNew

Chkbox is the name of the check box on the form

good luck
Erez

 

[golan]

thanks erez i add a new record bet but the new data update the last record
not the new !, the cursor is in the last rew\record not the new one.