Re: How to reference a value from a query in a form
Thank you for the help @arnelgp and jdraw.
I will post a copy of the database so its easier for you to see how I would like the format of the form.
On the 'Component in detail review' (the form) I would like it to show the overall cost as a value (box in there its just unassigned at the moment). Another important point is that I want to edit the values in the form.
If you think remaking the Form using Query previously mentioned as the record source. Adding the data from the Components list will work the best I will do this. (@arnelgp's method). But if there is better way you can think of that will work for this format I will do that.
I have tried remaking the form using the query but I am unable to edit the values shown so would need advice on how to overcome this.
Also I would not be editing the overall cost, I would be editing the two sub costs (Additional costs and Price (from the two tables Component list and Common products list respectively)
Last edited by norburao01; 08-15-2019 at 05:54 AM.