Search results

Ah okay.. you never mentioned in your earlier messages that it was a report that you wanted to 'refresh' - I just assumed that since you mentioned forms that you wanted to refresh a form. Good to see that you managed to help yourself and locate the information.

This might be a clearer explanation of what I need to do... Step 1) Get all customers.. Step 2) For each customer, get all jobs that are attached to that customer... Step 3) For each job, get the charges for each transaction attached to that job Step 3a) --> Return the sum of all...

Hi, I'm struggling to figure out this one but I hope there's some help here =] I'm creating an order system thing for a computer repair shopand basically I've got a table of 'transactions' (where money is paid for stuff) and a table of 'jobs' (a record of computers that need to be fixed)...

I apologise because I do not fully understand what you are saying. Yes, the code above will refresh the whole form after changing the value in the combobox. If you want it to 'refresh'/requery the whole form after changing a different area of the form, then you will need to use the same code...

I have a similar situation where I have a list of customers (CustID, Title, Forename, Surname) in a combo box above a number of fields where the customer details can be edited. I didn't quite understand your exact situation, but to 'refresh' the list whenever you change the value in your...