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.
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.