Searching Other Databases from a Form

[krispi]

Hi all

I have 2 databases, used for specific tasks in the office. I want to create a new DB for a new task.

I would like the new DB to include the functionality of being able to search for a specific value (a customer number) in a specific table of the other DBs and simply say 'yes' or 'no' if found.

Is this possible? I've never tried anything like this before, and Access help is not proving the answers. If soneone could give me a starting point I'd be grateful.

Thanks
Chris

 

[HitechUser]

Have a look at Linked tables. To your Access application the table will appear to be a local table. Then you can reference this table in forms, queries, or what have you!

You can use the link table manager or create a link using VBA code.

Search the help for DoCmd.TransferDatabase acLink...

Good Luck...

 

[krispi]

Thanks buddy - I'll give it a try!