Unanswered: Populate Form field with Query result from another Database
I have a query in database 1 that creates a field called Report ID. I have a form in database 2 that has a contol box that needs to be populated from the values of Report ID in database 1. Is there anyway to have the control source equal to the results of Report ID from the query? I would prefer to not have to create a table.
Populate Form field with Query result from another Database
Yes you can create a Query in Database2 using ReportID of the Query as source data from database1.
1. Create a new Query in Database2 and change it to SQL View (don't select any table for the query from the current database).
2. Type a SQL statement like the sample given below by making approproiate changes for the Query Name, Database name and location etc.
FROM Query1 IN 'C:\mdbs\Database1.mdb';
3. Save the Query with the name you want.
4. Open the Query in datasheet view to check whether the Data from Database1 is showing up as output.
5. You can use the new Query as source to populate your Form.
Last edited by apr pillai; 11-18-10 at 12:07.
Reason: correcton of text