Filling a combobox with data from a remote DB

[zawinulfans]

Hello everybody,
I need to fill programatically a combobox with data from a remote DB.

Dim dbs as DAO.Database
Dim rst as DAO.Recordset
Dim wrk as DAO.Workspace

Set dbs = wrk.OpenDatabase("\\fileserver\\datadb.mdb", True)

I need to populate a combobox from this remote database.

How can I do?

Many thanks in advance, all the best.

Marco (from Italy).

 

[Rolliee]

What do you wish to do with the cbo when you have successfully populated it?

One way would be to set the row source type to "Value List" and build a string from the foreigh table and plug it into the row source of the cbo.

Need a sample? Send your email and explain in it what you wish to do.

rollie@bwsys.net