There are some people here who use (or used to use)
VB, in addition to
Access, but it's primarily devoted to the Access product, not to all users
of Jet databases. This question would definitely have a better chance of
getting a good answer if asked in a Visual Basic newsgroup... USENET
newsgroups comp.lang.basic.visual.misc and comp.lang.basic.visual.database
are two; there are other sponsored newsgroups at news.microsoft.com (a free
news server).
I'm even having some difficulty remembering what a "datalist" is -- do you
mean a List Box Control?
Larry Linson
Microsoft Access MVP
"Martin Wulfe" <surveyman45-devx@yahoo.com> wrote in message
news:3ff4d792$0$202$75868355@news.frii.net...[color=blue]
> I want to use a connection to an existing MS Access database, but I want
> to be able to change which table is used to fill the datalist, using
> VB6, at run time by late binding the datalist to the table. Using
> either an ADO connection or an ADODC control, I can fill the datalist OK
> the first time, but when I try to clear it and fill it from another
> table, the contents of the datalist do not change. I must be doing
> something really dumb here, but I can't figure it out. Any help would
> be appreciated.
>
> TIA,
>
> Martin
>
> *** Sent via Developersdex
http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]
Refresh datalist contents 
