"WEG" <we******@verizon.netwrote
Is there a way to search from a form for
a record in one database, then if it is not
found in the first database, the search
continues in another database until the
record is found?
Yes, you can link the Tables in the different Databases, but the details
will depend on how you are planning to "search". If you are searching a
particular Field for a particular value, it shouldn't be too difficult.
But, just a caution, often people post here asking about "records in
databases" using terminology from other database software, when they really
mean "records in tables" in Access terms. That, too, would significantly
affect the details of the search (and possibly would indicate some design
issues with your database, too)
If you'd care to clarify, it's possible that someone could offer a useful
suggestion.
Larry Linson
Microsoft Access MVP