Requerying Listbox in an ADP

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

Hello,

Is there a reason that [controlname].Requery doesn't work in an ADP? To
requery a list box, I need to reassign the Rowsource in code. Is there a
way to use the Requery method. This is causing me a lot of problems for a
procedure I am writing.

God Bless,

Mark A. Sam
 
I could be wrong.. but I think .requery only works on bound controls..
so is your control bound to a procedure, or is it done in code?
 
No, it is unbound. It is used to goto selected records on the form. In
Access, Me.Requery will requery an unbound combo or listbox.
 
No, there is no reason and you don't have to perform a Requery after
changing the RowSource of a combobox as this done automatically by Access.

Probably that you have a syntax error in your Rowsource code.

Finally, there is a newsgroup about ADP: m.p.access.adp.sqlserver .
 
Thanks Sylvain,

I wasn't getting an error, but having procedural problems validating a field
to make sure it had a unique number. I went to an unbound form and solved
this.

God Bless,

Mark


Sylvain Lafontaine said:
No, there is no reason and you don't have to perform a Requery after
changing the RowSource of a combobox as this done automatically by Access.

Probably that you have a syntax error in your Rowsource code.

Finally, there is a newsgroup about ADP: m.p.access.adp.sqlserver .

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


Mark A. Sam said:
Hello,

Is there a reason that [controlname].Requery doesn't work in an ADP? To
requery a list box, I need to reassign the Rowsource in code. Is there a
way to use the Requery method. This is causing me a lot of problems for a
procedure I am writing.

God Bless,

Mark A. Sam
Click to expand...
Click to expand...
 
Back
Top