Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Wizards and referencing tables

Status
Not open for further replies.

SteveCulshaw

Programmer
Oct 13, 2000
48
GB
I've put together a wizard for form generation, but I want to fill a list box with a list of table in the 'user' database, i.e. the database where I'll be using the wizard, rather than the actual wizard database.

I've used CurrentDb and CodeDb to get at most of the things I need in the respective databases, but putting the wizards list box Row Source to "tblReports" doesn't work, as it points to a table in the wizard database, but the table I need "tblReports" is in the user database.

I've bodged things by creating a link from the wizard to the table in the user database, and this does work, but I feel there is a 'neater' way

Can anyone suggest what the syntax / solution might be ??

Cheers,
Steve C.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top