SteveCulshaw
Programmer
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.
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.