Im wanting to tie a subform texbox to a query result, I don't care if its tied to a button to start the query, but I'm not having much luck sorting this one out.
Ive attached a sample of my database. "Client" is my main form, "Invoice" is the subform that I want to populate the field "SumOfPremiumDue" on the "Invoice" table from the Query "Employee Query"
I have a button that runs the query, then I can cut and past the output result to my field, but I know I'm missing some simple code to get this working.
thanx in advance