J
J.Bennett
I had difficulties posting the first time. So, if this is a repeat, please
ignore.
I have a database that the user enters in information related to customer
name, address, etc., along with selecting the item to purchase (a storage
building in this case). Additional combo boxes allow the user to select the
options and the number of each option, new or used, discounts, colors, full
purchase or rent, etc. Based on the information selected, I have a query set
up that uses this information, calculates the price associated with the
building, the monthly payments, etc. This information is displayed on
another form named "outputform." I have error messages that appear on this
form to ensure all the necessary information has been entered properly. Once
all errors have been corrected, the next step is to simply print a report
that uses the information from the query.
As of now, it is very cumbersome in selecting the one record to use for the
query and I am seeking a better way to handle this portion. I currently have
a check box on the initial form that the user checks to "use this record".
The query simply uses the records that have the check. The problem is that
the user must be sure that all other records have be de-selected. The
resultes of the query is printed out on a report that looks like the
manufacturers "Dealer order sheet". If other records were selected, then
multiple sets of the "Dealer order sheets" are printed.
I would like to find a way to eliminate the need for the user to have to
select the specific record to use. The best case senerio is that the
specific record that is used for entering the information is caried forward
to the query so that it is the only one that is displayed on the "outputform"
and the only one that prints the "Dealer Order Sheets" report.
Can anyone offer a way of doing this? Any help would be appreciated. I
currenlty switch from one form to another using macros that close the
specific forms and opens up the next form and searches to find the "Use this
record" that is checked. I plan to change this to a TAB form so that these
are no longer needed. However, I don't know how to limit the records in the
query without requiring the user input.
I look forward to someone's response. Thanks.
J.Bennett
ignore.
I have a database that the user enters in information related to customer
name, address, etc., along with selecting the item to purchase (a storage
building in this case). Additional combo boxes allow the user to select the
options and the number of each option, new or used, discounts, colors, full
purchase or rent, etc. Based on the information selected, I have a query set
up that uses this information, calculates the price associated with the
building, the monthly payments, etc. This information is displayed on
another form named "outputform." I have error messages that appear on this
form to ensure all the necessary information has been entered properly. Once
all errors have been corrected, the next step is to simply print a report
that uses the information from the query.
As of now, it is very cumbersome in selecting the one record to use for the
query and I am seeking a better way to handle this portion. I currently have
a check box on the initial form that the user checks to "use this record".
The query simply uses the records that have the check. The problem is that
the user must be sure that all other records have be de-selected. The
resultes of the query is printed out on a report that looks like the
manufacturers "Dealer order sheet". If other records were selected, then
multiple sets of the "Dealer order sheets" are printed.
I would like to find a way to eliminate the need for the user to have to
select the specific record to use. The best case senerio is that the
specific record that is used for entering the information is caried forward
to the query so that it is the only one that is displayed on the "outputform"
and the only one that prints the "Dealer Order Sheets" report.
Can anyone offer a way of doing this? Any help would be appreciated. I
currenlty switch from one form to another using macros that close the
specific forms and opens up the next form and searches to find the "Use this
record" that is checked. I plan to change this to a TAB form so that these
are no longer needed. However, I don't know how to limit the records in the
query without requiring the user input.
I look forward to someone's response. Thanks.
J.Bennett