new to reports

[NickW]

I'm the owner of a DJ business and I would like to make contracts directly
from Access. If I'm thinking correctly, I should be able to have a report do
the same type of thing that a mail merge does in word? I'll just have
unbound text boxes and a picture, then the rest will be bound to table
fields. I don't want to continue to create this complex database if this
can't be done, so your help is appreciated. Thanks

 

[bhicks11 via AccessMonster.com]

This can be done. If you have a table with your customers, you create a
report how you want it to look (your contract). Then from a form, you can
either enter your customer for the first time or select the correct customer
and click a button on the form to generate the contract. When you click the
button to print the report (contract) you will have an onclick event that
does this:

DoCmd.OpenReport mycontract, acPreview

Set the data source in the report to the customer data, filter the data in
the report to the form (which has the current customer selected) - say you
have a custNo in your table and on the form:

CustNo=Forms!CustFrm.CustNo

This is rough but it will help you get started.

Bonnie
http://www.dataplus-svc.com