T
Terry
MBoozer,
Base your report on a query with the Locations table in
the query. In the criteria for the auto number field in
your query something like:
=forms![yourform].[subformcontrolname].[autonumberfield]
That should limit the report to printing only the current
record on your subform.
HTH,
Terry
Inventory data entry form contains the Chemical Name from
the Chemicals Table. The form also contains a subform on
locational information and this information is stored in a
different table called Locations. The two tables are
linked together with a one to many relationship. One
Chemical Name for many locations. The location record has
a Autonumber field so that each record is unique. This
Autonumber is the number I will be using for my barcode.
You just change the font on the AutoNumber field to a
barcode font that prints on a lable. Sounds fairly
straightforward.
enter the chemical name and then enter the location where
the container was found. As you might imagine, I will have
only a single chemical on this form showing many locations
for that chemical. I then want to be able to print a label
containing the Autonumber field from the Locations table
for the record I am currently working with. I have a small
single label printer that I will be using. How the heck do
you do this? I think what I want is a print control that
calls up a report. The report, when printed, will serve as
my lable. However, the report that is generated needs to
contain only the one record from the Locations table. I
suspect I need the report to be based on a query but I am
not sure how to do the query and make it so that the
report only contains the one record that I want to print.
Is this making sense? Is there another way to do this. I'm
a mid-level novice and I think I might be getting in over
my head but I can't give up. Should I be using a sub-form
maybe? I tried one but it prints all the records. Any help
is muuucho appreciated.
Base your report on a query with the Locations table in
the query. In the criteria for the auto number field in
your query something like:
=forms![yourform].[subformcontrolname].[autonumberfield]
That should limit the report to printing only the current
record on your subform.
HTH,
Terry
This is for a chemical inventory database. My main
Inventory data entry form contains the Chemical Name from
the Chemicals Table. The form also contains a subform on
locational information and this information is stored in a
different table called Locations. The two tables are
linked together with a one to many relationship. One
Chemical Name for many locations. The location record has
a Autonumber field so that each record is unique. This
Autonumber is the number I will be using for my barcode.
You just change the font on the AutoNumber field to a
barcode font that prints on a lable. Sounds fairly
straightforward.
will be using the main Inventory data entry form. I will
enter the chemical name and then enter the location where
the container was found. As you might imagine, I will have
only a single chemical on this form showing many locations
for that chemical. I then want to be able to print a label
containing the Autonumber field from the Locations table
for the record I am currently working with. I have a small
single label printer that I will be using. How the heck do
you do this? I think what I want is a print control that
calls up a report. The report, when printed, will serve as
my lable. However, the report that is generated needs to
contain only the one record from the Locations table. I
suspect I need the report to be based on a query but I am
not sure how to do the query and make it so that the
report only contains the one record that I want to print.
Is this making sense? Is there another way to do this. I'm
a mid-level novice and I think I might be getting in over
my head but I can't give up. Should I be using a sub-form
maybe? I tried one but it prints all the records. Any help
is muuucho appreciated.