List Box with ADO recordset

  • Thread starter Thread starter Amir
  • Start date Start date
A

Amir

I have a list box with the RowSource set on table linked
to a table in another database. I'm updating the data in
that table using ADODB recordset. When I add a new record
the listbox is not updated. But, if I delete one record
and then add new record, the new record is shown on the
list box. If I only modify or delete the record it's
working.
 
Have you tried doing a

YourListBox.Requery

To force a re-load? Does the above work?
 
Yes, I tried with the Listbox requery - It did not work
Then I tried with the setting the RowSource for the List
box - it did not work.
This problem appears only if I first try to add new record
after form is opened. If I modify or delete just one
record before adding a new record, it's working.
It's a little bit strange, isn't it?
 
Back
Top