Parameter and Command Button Print Envelope

[JoanOC]

I have an envelope report based on a query with a parameter.
The parameter connects the form that contains the command button with the
report.
This is so when the user hits the command button an envelope for the record
he/she is viewing will print.
Problem: The field on the form wont allow me to enter the prefix.
When I enter new records I need to run a query to enter the prefix field(s)
that are applicable to the record. (e.g.,Mr. and Mrs. or Ms. or Mr. or Dr.)
I have a text box that contains =Trim with the prerfixes available.
Prefix are in a table - combo box with value list.
Maybe I need to have the user enter the unique field and get rid of the
report parameter.
Help if you can.
Joan

 

[Jeff Boyce]

Joan

I'm confused. It sounds like you have a form on which you have a command
button to run a report (envelope), but do NOT have a "prefix" (?also known
as an Honorific, for the outside of the envelope?). From your description,
it sounds like you have a textbox (?on the form?) that is supposed to hold
your prefix(es?). But a combo box in a table?

And a report parameter? Do you mean a textbox on the report that you use to
solicit a parameter?

Another approach would be to:

have a field on the table that holds the name/address info -- [Honorific]
have a table that holds all (currently-known) Honorifics -- a value list

is harder to update/maintain when honorifics are added.

have a form that uses a combobox based on the tlkpHonorifics table, and

bound to the [Name_Address]![Honorific] field

 

[JoanOC]

I will try as you suggested, but the users will still have to enter whatever
the parameter is *type in caseid number* that I am trying to avoid.I realize
it is confusing.
The users are attorneys who are known for not embracing the compter so I
need to make the form they use as simple as possible.
I may just put the caseid number next to the command button so they can type
it in when asked for the parameter (caseid).
Thanks for your help.
Joan

Joan

I'm confused. It sounds like you have a form on which you have a command
button to run a report (envelope), but do NOT have a "prefix" (?also known
as an Honorific, for the outside of the envelope?). From your description,
it sounds like you have a textbox (?on the form?) that is supposed to hold
your prefix(es?). But a combo box in a table?

And a report parameter? Do you mean a textbox on the report that you use to
solicit a parameter?

Another approach would be to:

have a field on the table that holds the name/address info -- [Honorific]
have a table that holds all (currently-known) Honorifics -- a value list

is harder to update/maintain when honorifics are added.

have a form that uses a combobox based on the tlkpHonorifics table, and

bound to the [Name_Address]![Honorific] field

have a query, using the values of the selected record/form as its parameters
have a report, based on the query
use a command button on the form that opens the report

--
Good luck

Jeff Boyce
<Access MVP>

I have an envelope report based on a query with a parameter.
The parameter connects the form that contains the command button with the
report.
This is so when the user hits the command button an envelope for the record
he/she is viewing will print.
Problem: The field on the form wont allow me to enter the prefix.
When I enter new records I need to run a query to enter the prefix field(s)
that are applicable to the record. (e.g.,Mr. and Mrs. or Ms. or Mr. or Dr.)
I have a text box that contains =Trim with the prerfixes available.
Prefix are in a table - combo box with value list.
Maybe I need to have the user enter the unique field and get rid of the
report parameter.
Help if you can.
Joan

 

[JoanOC]

More:
1. I have a clients table that contains the prefixes with a lookup:combo box
with value list.
2. I have a form that contains a command button that opens the envelope
report.
3. The form also contains the prefixes from my clients table (#1 above)
4.The envelope report contains a parameter: =[Forms]![Clients]![txtClientId]
that connects the envelope and record. (unique field)
Problem:
I cannot enter a selection from the lookup value list that is on my form.
I need to run a query to do so.
Problem 2:
I need to know how to create a proper string that contains all the prefixes.
I ended up creating 2 command buttons because I didn't know how to do this.
Exhausted. Hope you can help. In the meantime, I will try what you suggested.
Joan

I will try as you suggested, but the users will still have to enter whatever
the parameter is *type in caseid number* that I am trying to avoid.I realize
it is confusing.
The users are attorneys who are known for not embracing the compter so I
need to make the form they use as simple as possible.
I may just put the caseid number next to the command button so they can type
it in when asked for the parameter (caseid).
Thanks for your help.
Joan

Joan

I'm confused. It sounds like you have a form on which you have a command
button to run a report (envelope), but do NOT have a "prefix" (?also known
as an Honorific, for the outside of the envelope?). From your description,
it sounds like you have a textbox (?on the form?) that is supposed to hold
your prefix(es?). But a combo box in a table?

And a report parameter? Do you mean a textbox on the report that you use to
solicit a parameter?

Another approach would be to:

have a field on the table that holds the name/address info -- [Honorific]
have a table that holds all (currently-known) Honorifics -- a value list

is harder to update/maintain when honorifics are added.

have a form that uses a combobox based on the tlkpHonorifics table, and

bound to the [Name_Address]![Honorific] field

have a query, using the values of the selected record/form as its parameters
have a report, based on the query
use a command button on the form that opens the report

--
Good luck

Jeff Boyce
<Access MVP>

I have an envelope report based on a query with a parameter.
The parameter connects the form that contains the command button with the
report.
This is so when the user hits the command button an envelope for the record
he/she is viewing will print.
Problem: The field on the form wont allow me to enter the prefix.
When I enter new records I need to run a query to enter the prefix field(s)
that are applicable to the record. (e.g.,Mr. and Mrs. or Ms. or Mr. or Dr.)
I have a text box that contains =Trim with the prerfixes available.
Prefix are in a table - combo box with value list.
Maybe I need to have the user enter the unique field and get rid of the
report parameter.
Help if you can.
Joan