This was good.It made my form close, and when opened again the fields were clear. I also tried the DoCmd.Restore and it did just the same clearing out my fields without closing my form. Thanks again!!!...

Thanks, but I wasn't trying to ask you to do it. I think I needed more direction on creating my form combo boxes. But I figured that out and now I am on to a different area of confusion. I took this one off of the forum not sure why it is still there. Thanks for your help though....

Hello,
Not sure if my title was correct, but here is what I am dealing with. I have created a DB that contains different tables that are linked to a form through combo box's. I have createad a command so that once all the entries are selected in the combo box it will save on to a table. What I want is after I save the entry. I would like for the form to close and clear the data that was entered last. I am no expert on VBA code and I need help....

Hello,
I am running into an issue with adding a form that displays a calendar to where the manager can click a day and it will attach itself to a tracking table. I am new to this and have been given this project as a learning exp. I need all the help I can get on where to begin.

I have created tables- one of with employee information, another with reason codes for day off requests (such as jury duty, vacation, sick time, etc)....