I have a form where the user enters data on the specifications of a bag and there is a query and a report to get the result of the exercise - the bag weight
It would be a good idea to have the result - the bag weight in the Form as soon as the user fills in all the data, like we get in Excel.
When I added the query field, the existing query data in all the records were updated!
Surprisingly now I am unable to add any new records in the form! If this was possible, the user would have to run the report or query to see this information!
Form name: frmUserInput
Final Query with bag weight : qryBagWeight2
Field name : BagWeight
The DB is enclosed.
It would be a good idea to have the result - the bag weight in the Form as soon as the user fills in all the data, like we get in Excel.
When I added the query field, the existing query data in all the records were updated!
Surprisingly now I am unable to add any new records in the form! If this was possible, the user would have to run the report or query to see this information!
Form name: frmUserInput
Final Query with bag weight : qryBagWeight2
Field name : BagWeight
The DB is enclosed.