External RecordSource

  • Thread starter Thread starter JonWayne
  • Start date Start date
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?
 
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 . . .
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two tables for One form 3
Setting recordsource property in VBA Access 2007 7
SourceObject and RecordSource 8
Modify Record source for form with VBA 2
expression that has no value 4
How to Apply Current Recordsource? 13
code worked in Access 2003, not Access 2007 1
Set Recordsource for a subreport 4

Back
Top