Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Place selected data & prompt 4 additional data to be printed on label

Status
Not open for further replies.

mhansler

Technical User
Feb 19, 2001
24
US
Simple question I'm sure. But I need assistance.

The goal is to print one mailing label at a time. Maybe 4 etc. Pick and choose who they want to print labels for off and on all day long. Prompt for additional info and have it all placed nicely on a label to be printed and placed on a folder. (later they may want that info they prompt for saved. at this time they don't.)

This is what I've done. I created a form with a drop down list (combo box) that displays the entire lists of funeral homes in abc order. They pick the funeral home in question. (This part works)

After selecting the funeral home, I need to prompt for a deceased person's name, a claim number and the claim rep handling the case.

Then I need to display that info all nice and stuff on a label for them to print along with the Funeral Home's fax and phone number, like so:

Deceased Person Claim Number
blank line
Funeral Home Name
Phone Number
Fax: Fax Number Claim Rep.

FH contact info is already stored in an access table.

Things to keep in mind. They can print one label or 5. The need to be able to pick where to print on the label sheet so they don't waste labels.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top