Access 2007 Macro design help

[retired fire]

I need suggestions to create a macro that will open a table, go to a record,
and then open the attachment of that record. Can this be done????

I currently have many macros that work great, but with the new Access
feature that allows attachments to be hooked to a record, that functionality
helps me alot. I need the macro to go to a specific table, then go to a
specific record, and then go to the attachment field, and open the attachment
(for example- a Word document).

I have added the attachment field to the records in the table, and all is
well with the tables.

Any suggestions or guidance is appreciated, as I made a short post in the
macro discussion group without any reply. Thanks

Thanks for any help....

 

[retired fire]

Guess the MVP's have no clue on this one.... oh well it was worth a post to
see if someone had a clue.... guess not....