Requerying Listbox in an ADP

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
 
B

Beacher

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?
 
M

Mark A. Sam

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.
 
S

Sylvain Lafontaine

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 .
 
M

Mark A. Sam

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...
 
Top