Hello,

I'm a newbie.

I have a report which runs over a table in a database but I need to be able to change the database and table at runtime. The databases/tables are in the same format and I've created my report using the report wizard. The report runs when I click a command button with the following code

REPORT FORM rptCredit.FRX TO PRINTER PREVIEW FOR currbal < 0

How can I switch to running the report at runtime over tableB in databaseB when it has been created at designtime using tableA in databaseA?

Any pointers gratefully appreciated.

Sharon