I have an unbound textbox and a subform on a form. The subform is attached to a table that contains a field that holds charge amounts. When the main form is displayed the subform will display all charges that are associated with the main record.
Below the subform I have a "Total" in a textbox. I have a query that sums up the charges for the main record. I want to be able to display the total from the query but I do not know how to call the query and have the result put into the textbox.
Me.txtTotal.Text = qryPrepaid.Prepaid
This does not work.
Please help. Thanks.
Below the subform I have a "Total" in a textbox. I have a query that sums up the charges for the main record. I want to be able to display the total from the query but I do not know how to call the query and have the result put into the textbox.
Me.txtTotal.Text = qryPrepaid.Prepaid
This does not work.
Please help. Thanks.