Report to print one address label

M

Mort

Ok, at it's most basic, I have a database with a list of people in it and a
form to display this info. I would like to place a button on the form that
would print the address (shown on the form), and not all the addresses in the
database.

Do I need to create a query first? and if so, how do i get the query
criteria to update automatically? Or can the report generation simply "lift"
the data from the form?

I'm sure this is an easy one, but not knowing too much about Access and
after trying for a good few hours, i thought it time to ask the experts :)

What do you think?
 
M

Mort

Hmmm, i don't think that's what i'm after. The person's name is in a txt box
and the address is in a memo field (with carriage returns). I basically just
want to pipe the text from those two controls to a blank report for printing
(or bypass the report entirely if possible)

The "print" button should only ever print the address of the person whose
record is being viewed.

What do you think?
 
R

Rick

this works for me to print a single record. with your form on the screen, go
to view, select design view, then select toolbox, select command button on
the toolbox, drag the command button to where you want it on your form and
release. i think you can find your way from that point.
 
M

Mort

Hmm, printing a record is fiine. the trouble is, i only want to print two
fields from a record...
 
M

Mort

okay, i've been playing around with the DoCmd, hoping i'm in the right area.
This kinda works, but i can't work out how to filter the output to just the
UserName variable

Thoughts?

UserName = [RepName] & vbCrLf & [RepAddress]

stDocName = "006 - Print Address"
DoCmd.OutputTo acReport, stDocName
 
Top