A
Acie
Has anybody experienced a requery problem ?
I have the following issue:
I have a listbox filled with names via a query. The user
selects one name and clicks a button. The button basically
builds an sql and deletes the name from the table via ADO.
The delete works fine. However, then I do a
docmd.requery "listbox" or a listbox.requery
which should force the listbox to requery, which in effect
would redisplay the original list but without the name
that was deleted.
Well, it doesn't do anything! However, if I select a
second name and click the button, then it removes both the
first and second name, and then it works well from then
on..
Anybody experience this ? Any ideas ?
Thanks,
Acie
..
I have the following issue:
I have a listbox filled with names via a query. The user
selects one name and clicks a button. The button basically
builds an sql and deletes the name from the table via ADO.
The delete works fine. However, then I do a
docmd.requery "listbox" or a listbox.requery
which should force the listbox to requery, which in effect
would redisplay the original list but without the name
that was deleted.
Well, it doesn't do anything! However, if I select a
second name and click the button, then it removes both the
first and second name, and then it works well from then
on..
Anybody experience this ? Any ideas ?
Thanks,
Acie
..