I have a database with several complex reports (each running at least 40 queries (while some run up to 90 querries) to prepare the data for the reports requirements).
Basically I have a combo box where sales order numbers are entered, upon a click event for this control a series or queries are run and forms opened and closed to pull the products associated with the sales order, and then pull the component parts used for making product before running cost generation information.
Recently it was discovered that for the field where "Scrap Pounds" are entered an error occurs when the subcomponents are measured in "Feet". To fix this problem I want to auto-convert the value within txtScrapLbs to feet on the fly. I already have the queries written which will test the unit of measure for the component parts for "FT" and can run conversion information within isolated queries. Rather than rewrite perfectly functioning queries to massage the data "in process" I want to just convert the data at the time of data entry and have all table records begin with the correct values.
My problem rests in that I want to make the update query update not a table record, but a form text box value.
Has anyone else successfully done this before?
Any thoughts on how to structure this?
Basically I have a combo box where sales order numbers are entered, upon a click event for this control a series or queries are run and forms opened and closed to pull the products associated with the sales order, and then pull the component parts used for making product before running cost generation information.
Recently it was discovered that for the field where "Scrap Pounds" are entered an error occurs when the subcomponents are measured in "Feet". To fix this problem I want to auto-convert the value within txtScrapLbs to feet on the fly. I already have the queries written which will test the unit of measure for the component parts for "FT" and can run conversion information within isolated queries. Rather than rewrite perfectly functioning queries to massage the data "in process" I want to just convert the data at the time of data entry and have all table records begin with the correct values.
My problem rests in that I want to make the update query update not a table record, but a form text box value.
Has anyone else successfully done this before?
Any thoughts on how to structure this?
