External RecordSource

J

JonWayne

Is there a way to make a table in an external database the RecordSource of a
form in the local database? How, if so?
 
M

Marshall Barton

JonWayne said:
Is there a way to make a table in an external database the RecordSource of a
form in the local database? How, if so?
Click to expand...


Use a query with the IN phrase in the FROM clause:

SELECT table.fielda, . . .
FROM table IN "pathtootherdb"
WHERE . . .
ORDER BY . . .
 
M

Marshall Barton

JonWayne said:
Is there a way to make a table in an external database the RecordSource of a
form in the local database? How, if so?
Click to expand...


Sheesh, I forgot to mention the easy way, just link to the
table in the other db.
 
Top