Print a label report from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want production to enter into a form the product code, manufactured date,
lot#, received date - where the lot# and received date together make the
record unique. I created a label report based on this form but want them to
be able to print out the labels only for the newest record that they entered
in. I added a command button that previews the report but it shows ALL
records and I only want the most recent record printed out. I also would like
the label to be repeated 3X on the one sheet - 3 labels/page. Right now I
have the 3 labels per page but they are all three different labels for each
record - I would like them to be all the same. I know I could add a
parameter query to the report but that would make them reenter data. any way
to get around this.

Thanks,
Barb
 
hi,
if you are not using a query to select the last record,
the the report will try to print the whole table.
Product code
mfg date
lot#
r'cved date
I see not record number. If r'cved date has at time stamp,
you could use max r'cved date. but this might cause you to
write 2 queries.(why? cant use group by with Max)first
query would select the max r'cved date first query would
be used in the second guery to select all field matching
the Max r'cved date.
the second query would be the report's record source.
If r'cved date does not have a time stamp, then you should
consider a record number. and select max record number.
the 2 queries would prevent a parameter query.
to print 3 times add code to print 3 times.
hope this helps
 
thanks for the input, I do have an autonumber field and I can do the max to
that. for the print out 3x I have used VB but not a ton- do I tie an event
procured to the on click of the command button and what would the Print code
say to get 3 labels on the same sheet( 3label sheet)and not 1 label per sheet
3x

Thanks,
barb
 
Back
Top