Requery doesn't work immediately

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

After I update a recordset using ADO, I ask the listbox
to requery the source, but it doesn't show the
new/changed record. Reloading the form updates the
listbox. My guess is that it is too soon to requery the
source when it has just been updated. Can anybody help me
solve that problem?

Sam
 
I think there is no way it is too soon to requery. My guess is the
record source of the list is dependent on the record source of the form,
and you have requeried the rst of the list but not of the form.
If re-opening the form cures it, this means that requery of the form
should do the same. Make sure to do Me.Form.Recordset.Requery before you
do Me.Listbox.Requery

Pavel
 
Back
Top