Hey,
I have a form which has a command button to run two queries...one to update the labour cost from the hours worked field and one to then update the total cost by adding the labour cost to parts cost. These queries work fine and it updates the table fine however, it doesn't display the results in the table instantley. You must navigate off the record and then back to the record in order to display the results. Is there any way of making it update the form values when you click the button as well as updating the table values?
Many Thanks
Chris
I have a form which has a command button to run two queries...one to update the labour cost from the hours worked field and one to then update the total cost by adding the labour cost to parts cost. These queries work fine and it updates the table fine however, it doesn't display the results in the table instantley. You must navigate off the record and then back to the record in order to display the results. Is there any way of making it update the form values when you click the button as well as updating the table values?
Many Thanks
Chris
