Automating filling out a pdf

[TerraEarth]

So I have data on a database that I would like to use to fill out fields on a PDF form. The PDF form is already designed and has fillable fields/signature box/checkboxes/etc. on it.

What I am thinking of doing is, copy the template, empty-field PDF to another folder, rename it to some entry-specific title (like CustomerID'sPDF or something along those lines) and then fill it out and repeating the process as many times for as many records as necessary.

Any suggestions on how I should start to tackle this problem and what I should look up?

[NTC]

As you describe it - - what you need to do is go to an Adobe forum and find out if a pdf can link to an Access table/query.

From the Access side - - you can open a Report, then right click - and export it as a PDF. This may work fine - but it is not a fit with your description of filling in a pre-made PDF template. It is quite simple and widely used as many reports need to be shared in PDF format.

[TerraEarth]

That is correct, what I need is not printed reports, but actual field fill-ins, as this document is going to be passed on and filled in by other people as well.

I was able to find some code that actually writes to fields in a pdf, given that you know the names of said fields.

The only thing I have to do now is to set it up so that this code is run for every entry in my relational database with their respective values. Does anyone know the best way to go about doing this?

[June7]

Code that opens and cycles through recordset.