Report with no record source Problem

[Guest]

i have a report that im using as an envelope. i have a number of text boxes
on my report whos control sources are for example:

forms!frmAddressBook!name
forms!frmAddressBook!Address

So from the address ook form the user can click a button a print an envelope.

What im trying to do is when my user prints a form and there is no name in
the address book, just a company name, then to display a pop up box for the
user to entre a FAO value. eg Accounts Department.

Me.FAOtext.ControlSource = "For The Attention OF"

it doesnt work because the report has no records source. if i attached a
qry to the report it works but prints out multiply envelopes depending on the
size of the qry.

Is they are way to get a prompt message box for he user to add an FAO name
onto the envelope report without having to attach a record source to the
envelope report??

 

[Duane Hookom]

You haven't suggested why you don't base your report on a query that limits
the record source to one record.

However, you could prompt the user and place a text value in a text box on
your form. Then add a text box similar to the existing text boxes on the
report.

Dim strAttentionOf as String
strAttentionOf = InputBox("Enter Attention Of")
Me.txtAttentionOf = strAttentionOf