Hey Klaas, I need more information. I haven't seen the video in ages so you'll have to explain a little more. So you have a task form, with an order detail subform on it. Then you have a button that does what? Goes to a new record or does it set all the values to ""? What is the code in your button?

Then you want the order detail subform to also be blank when you push the button, right?

Hi Adam,

Everything is in Dutch, sorry for that.

Image 1 is the Task form, which contains the fields and the sub form called PartsOrderDetailF

Image 2 is the New Task Button.
With this button I want to clear all fields in both the Task form and the Sub form, so that a new Task and newly used parts can be added.

I like to hear from you.
Gr. Klaas

OK, does it go to a new record though or is it just clearing out the fields? I assume it's going to a new record and not just deleting everything, if you select your subform in design view you should see in the Data Tab Link Master Fields and Link Child Fields, are there any values in those?

OK you are going to a new record then yes, I assume you have some kind of relationship between the tasks and the order details? That ID field should be put into the Master/Child fields I mentioned previously.

The last Image is from the Video's.
So now I want to have the OrderDetailF Form in my Taskform.

So what happens when you push your button and go to a new record? If the subform is linked it should clear out and be linked to the new blank record. Does it show the last records information still in the order details?

Should also be fine with just
DoCmd.GoToRecord ,,acnewrec

When I push the Button, only the Mainform is cleared. Not the Subform. So I can not check if the records remain in the Order Details.

Sorry, I'm having a hard time understanding what is actually happening. Can you take a screenshot of a record how it should be, and then a screenshot of that same record after you push the new record button? Where the main form has cleared out but the bottom form has done nothing?

What happens if you do either of these? (Replace ParentFormName and SubFormname with your actual form names)
DoCmd.GoToRecord ,,acnewrec
Forms!ParentFormName!SubFormName.Form.Refresh
or
DoCmd.GoToRecord ,,acnewrec
Forms!ParentFormName!SubFormName.Form.Requery

Sorry for the bad explanation.
Underneath are Screenshot 5 and 6.
Screenshot 5 is the Task Form filled with data. Screenshot 6 is the Task Form with all the cleared fields. This data is Stored in the Task Table. So far so good.

The Subform named: OnderdelenOrderDetailF, This Subtable needs also to be cleared together with the Task Form and the data stored in the OnderdelenOrderT (Table).

If both Forms are cleared, The data from the Task is stored in the Task Table. And the data from the OnderdelenOrderDetailF is stored in the OnderdelenOrderT.
But if I reopen the previous Task, I see the data from the Task Table but not from the OnderdelenOrderT (Table).

Does this explanation makes more sence?

I've placed the code:
DoCmd.GoToRecord ,,acnewrec
Forms!ParentFormName!SubFormName.Form.Requery
Into the Button.

But it will not clear the Subform OnderdelenOrderDetailF

Of course I changed the code to the right ParentForm and SubForm names.

I don't think you have a relationship then, if you can enter records in that subform and then when you leave the record and come back and they aren't there. It's either the child/master fields which you already showed appear to be correct, or the OnderdelenOrderID isn't being created in the subform records when you add stuff in there. You could try going into the subform and changing the default value of the OnderdelenOrderID to Forms!ParentForm!OnderdelenOrderID so it would make sure it's inserted.

Thank you Adam.
I will try changing the default value. See how it goes.