Unbound combo box doesn't refresh; datagrid displaying filtered recordset doesn't show new added record
Posted on 2003-11-05
I 'm encountering the following errors in VB6 & AdoDB
1. In a datagrid that displays the data of a filtered recordset, newly added records disappear from the datagrid. Click next to the * that denotes a new record in the datagrid, add a new record, move to a different row and find out that the row disappears. If you rerun the project, the row is there. It has to do with the rs.filter command but still can't figure out why it behaves like this and how to remedy the problem.
2. The other problem has to do with how to refresh an unbound combo box. I have an unbound combo box that is filled with names from a table. It is used for selecting a name and then navigating to the selected record. When, a new record is added, or an existing record is modified, or a record is deleted, the unbound combo box is not refreshed.
Could anyone please offer his experience into any of the above? I 'm using MS-Access 2000 (Jet 4.0) with VB6. I could attach a sample project to demonstrate the above but don't know if I can in this forum.