How do I access a database table from a macro to

[mcmahak]

How do I access a database table from a macro to retrieve data from a cell from that table. Thank you

 

[Gates Is Antichrist]

That's really too big a question to answer here, so without being coy I would point you to an Access book. Meanwhile, or if you really want to wing it, I'd start in the Access help file with the topic "Recordset Object." It's pretty involved, but it can become second nature eventually. You need to grasp the object hierarchy - so you would probably need to run though all those arcane looking help links at the top there. Trust me - it's easier with a book

Or at least that's how *I* access Access data in macros