PDF Command button

[Guest]

I have 2 tables.

1. a list of contracts with a primary key of the bid number
2. a list of documents the a foreign key of the bid number. There is a
hyperlink field in this table to the newtwork location of the documents.

Ther is a one to many relationship for contract to document through the Bid
number key.

I have a form with a sub form that lists the documents associated with the
bid number. I would like to have a command button on the end of each line in
the subform that will open the document based on the hyperlink on that row of
the table. Therefore each row should have a command button that opens the
document for each line.

I have eevrything all set except the buttond for each line, I am sure it is
easy, but after working on this all day I am missing it.

Thanks for the help

 

[Jeff Boyce]

Michael

You mention having "each line" in your subform. We're not there, so we
can't see how you've set up your subform. If you're using a datasheet, I
don't believe you'll be able to do this.

But you could use a "continuous form", make it look a lot like a datasheet
view, and still be able to add in a command button.

Good luck

Jeff Boyce
<Access MVP>