C
ChuckW
Hi,
I have a table called Customers that has basic adddress information. I have
create a form called Main Menu and a combo box called Select Customer and a
command button called ShippingReport which runs a Shipping Report. I have it
so that a user selects a customer from the drop down combo box and the
address information shows on the Shipping report. What I am also trying to
do is to add additonal information that the user would select for the report.
This includes Shipping Method and Special Instructions. These fields are not
in my customer table so I created separate ones for each. I then created
queries for them and then subforms which I added to the main form. I also
created subreports so that this information will appear on the overall report.
For Shipping Method, I created one field which is numeric. On the
ShippingMethod subform there is an option group that has three options (2nd
Day, Next Day and Ground). When a user selects one it saves it as a value of
1,2 or 3 in the ShippingMethod field). For special instructions, I created a
memo filed in a table and then a subform where someone could write out
special instructions.
I am not trying to save the data that the main form and subforms create. I
am simply trying to run a report with this information and then print it out
and place it in a shipping box. So once the information is printed I want to
clear everything. I don't have any common fields that link the main form to
the subforms either. Any ideas and how to make this work? Perhaps some kind
of button that wipes out all of the information in the report and allows the
user to reenter information.
Thanks,
I have a table called Customers that has basic adddress information. I have
create a form called Main Menu and a combo box called Select Customer and a
command button called ShippingReport which runs a Shipping Report. I have it
so that a user selects a customer from the drop down combo box and the
address information shows on the Shipping report. What I am also trying to
do is to add additonal information that the user would select for the report.
This includes Shipping Method and Special Instructions. These fields are not
in my customer table so I created separate ones for each. I then created
queries for them and then subforms which I added to the main form. I also
created subreports so that this information will appear on the overall report.
For Shipping Method, I created one field which is numeric. On the
ShippingMethod subform there is an option group that has three options (2nd
Day, Next Day and Ground). When a user selects one it saves it as a value of
1,2 or 3 in the ShippingMethod field). For special instructions, I created a
memo filed in a table and then a subform where someone could write out
special instructions.
I am not trying to save the data that the main form and subforms create. I
am simply trying to run a report with this information and then print it out
and place it in a shipping box. So once the information is printed I want to
clear everything. I don't have any common fields that link the main form to
the subforms either. Any ideas and how to make this work? Perhaps some kind
of button that wipes out all of the information in the report and allows the
user to reenter information.
Thanks,