D
Dan M
Access XP ADP using SQL Server 2K back end.
Using the following code to attempt to requery a listbox.
The code is in a standard module, used to requery list and
combo boxes on open forms when other forms have inserted
or updated data and been closed. Works fine in 97.
Forms!frmMaintenance!lstManagers.Requery
I have tested it using a table, SQL statement and stored
procedure as the rowsource of the listbox. The form in
question is open. I fully qualify the reference to the
listbox (I even referenced it to overkill with the form's
controls collection). I've used a variable of Control
type, and tried to call the Requery method. Nothing works.
I can fully reference the value of the listbox, and it
sees the value of the selected row:
Forms!frmMaintenance!lstManagers.Column(0)
I can call the requery method from within the form's
module, and it works. But I must make the standard module
work.
REQUERY just doesn't seem to work. Is it because I'm
working in an ADP file? Is there a workaround?
Using the following code to attempt to requery a listbox.
The code is in a standard module, used to requery list and
combo boxes on open forms when other forms have inserted
or updated data and been closed. Works fine in 97.
Forms!frmMaintenance!lstManagers.Requery
I have tested it using a table, SQL statement and stored
procedure as the rowsource of the listbox. The form in
question is open. I fully qualify the reference to the
listbox (I even referenced it to overkill with the form's
controls collection). I've used a variable of Control
type, and tried to call the Requery method. Nothing works.
I can fully reference the value of the listbox, and it
sees the value of the selected row:
Forms!frmMaintenance!lstManagers.Column(0)
I can call the requery method from within the form's
module, and it works. But I must make the standard module
work.
REQUERY just doesn't seem to work. Is it because I'm
working in an ADP file? Is there a workaround?