Assuming that the "frmDetails" is the form that contains these procedures you are probably haveing the problem because by calling the form_close() procedure from the txtDate_Gotfocus() procedure the txtDate_Gotfocus() can't complete until the form_close() jprocedure completes. There for the form is trying to close while the txtDate_Gotfocus() procedure is still running.
Try putting the procedures together as one in the txtDate_Gotfocus() procedure such as
private sub txtDate_Gotfocus()
hi, thanks 4 ur help. I tried that but it didnt work. what i did was from the form that I used to open this one up, after everything was done it closed the form from there and not in the form i opened.
I really luv it when you click help in access and no topic is displayed!