A
anandkhinvasara
I am using an combobox based on a recordset (adOpenDynamic,
adLockBatchOptimistic) and populating it on FORM LOAD
Set cboName.Recordset = rsTemp
I make an entry to the table on which this recordset is based through
SQL Statement.
After this I requery my combobox
cboName.Requery
But I do not see the newly added record here. I have to close the form
and reopen it again to see the new record.
I have also tried requerying the recordset on which the combobox is
based, before requering the combobox..But didn't work ? Please advise
on this.
adLockBatchOptimistic) and populating it on FORM LOAD
Set cboName.Recordset = rsTemp
I make an entry to the table on which this recordset is based through
SQL Statement.
After this I requery my combobox
cboName.Requery
But I do not see the newly added record here. I have to close the form
and reopen it again to see the new record.
I have also tried requerying the recordset on which the combobox is
based, before requering the combobox..But didn't work ? Please advise
on this.