I have a button on my form which when it creates a new recored it puts the current date and time into the relevent boxes. This works when there is no records in the tables but after the first record has been entered the button fails to work and it just sits there. I have got a feeling it could be to do with the record that is already been dispalyed in the boxes. It works fine when the macro is disabled and the date and time is entered manually. I think i need to have the date and time boxes empty when the button is pressed but i don't know how, any ideas?

I have now fixed this problem by setting the date and time as the default values