Automatically update data

[scoe]

Hi



Hope someone can help, I have a combo box for number of days and a tick box for milage if over 3 miles. In the combo box I have an event procedure that determines the amount paid depending on whether the milage box is ticked and the number of days e.g. 1 day with no milage £20 1 day with milage £30. This is broke down to show the amount per month.

My problem is that I want the data to refresh if a tick is put in the month box without having to re-enter the number of days in the combo, can anyone help please?

Thank you

[RuralGuy]

Is your Form bound to a table/query? Are these Controls bound?

[scoe]

Thank you for replying, the form was bound to a table, however I have just sorted the problem and it is working perfectly.