How do i refresh a form in access

[DavidPT]

I have setup a form that also has a subform in it. The form just shows the date and the subform holds all the other information such as Name, Task, Hours and Comments. Three of these options are setup as combo boxes.

I want to setup a refresh button so when pressed it will refresh the page so other users can type there information with all combo boxes being blank. At the moment all the combo boxes are showing the previous entry.

I have tried setting up a command button using the wizard but when clicked i am getting the following error message "The command or action 'Refresh' isn't available now."

I have tried other steps such as coding in Me.refresh and other things but with no luck. I also tried adding a requery on the 'on current' area in the form with know luck.

Any help would be appreciated.

[GazMathias]

By "refresh", you actually mean "create new record", so that's what you'll need the button in the wizard to do, if you've got the Navigation buttons shown on the subform, there's one already there: it is the button that looks like ">*" where you see [ |< < 1 > >| >* of x ]

[NeoPa]

I know it's not your main question, but I see you have a a subform involved to allow you to show the Date on the main form.

May I suggest you use the one form, but simply have the Date in the Header section. It will make your life a little less complicated.