Print button on form for single record

[Lin Light]

I have a table, with a P.K. auto-assigned by Access.
Table is for books on order and there is a field called ISBN.
I have a query built to pull up a record by ISBN.
I have a form built upon this query where again I key or scan in the ISBN of
the book that we are checking in off an invoice. The form has windows for us
to enter data for invoice and processing date and a check box for received.
I have a report that prints out certain information off this table but when
I open the form, enter the data and then go to print the report for that
single record I have to enter the ISBN again. I have tried to do the same
thing but with the data source being the table and it starts printing the
whole list.
I have tried a couple of things I have found in other discussions, but to no
luck.

Lin

 

[Allen Browne]

See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

Don't forget to add the quotes if ISBN is a Text type field (not a Number
field when you view it in table design.)

 

[Lin Light]

Thanks got it going now.
How about the issue of a blank record showing up in query results.
Got an answer for that one.

Lin

 

[Maverick]

Have your query check, in the criteria, for Null and empty string values and
omit them (as in does not equal).

Also, please be sure to mark the question answered by saying the post was
helpful to you. This makes it so that people know that they can use your
question as a resource. Plus, Allen deserves credit for helping you.