One Query, One Form, about 15 databases

[ChaseCox]

How can I take a form I made that used one query, one database, and transport it to use about 15 databases, and a different query, but with the same info in the query and tables? Thanks!!!

[ChaseCox]

How can I take a form I made that used one query, one database, and transport it to use about 15 databases, and a different query, but with the same info in the query and tables? Thanks!!!

I still need some help with this. Thanks!!!

[MMcCarthy]

How can I take a form I made that used one query, one database, and transport it to use about 15 databases, and a different query, but with the same info in the query and tables? Thanks!!!

Chase I'm not sure what you mean about 'use' 15 databases. If you just mean you want to use this form in each of them then export the form to the database and in the new database in form design view change the Record Source property of the form to the new query.

Just remember if any of the fieldnames are different, missing, etc. you will have a problem.

Mary

[Killer42]

Chase I'm not sure what you mean about 'use' 15 databases. If you just mean you want to use this form in each of them then export the form to the database and in the new database in form design view change the Record Source property of the form to the new query.

Just remember if any of the fieldnames are different, missing, etc. you will have a problem.

You might also want to attach the tables from the fifteen different databases to a "front end" database, then use a UNION query there to pull them together. You might not, too. :) There are performance issues involved.