Refresh subform

[Soegstad]

Hi
I have a problem with a subform.
I want to refresh the subform (named frmOrderSUB) everytime I start a new record the main form (named frmOrderMAIN).
In other words, every time I push >* in the main form I want the subform to refresh and have no records in the pulldown menu.
Thanks for your help.
Mads

 

[Rich]

Isn't the subform linked to the main form by some child master field?

 

[Soegstad]

I have a field in the subform that links to the main form Autonumber (=[Forms]![frmOrderMain]![OrderID])

 

[Rich]

Do you not have OrderID as the FK in your OrderDetails table?

 

[Soegstad]

The order ID is linked from main to sub (one to many realtionship)

 

[Soegstad]

I have a one to many relationship between the OrderID fields in the main form and the sub form

 

[Rich]

Then you just need to set the Child/Master link for the subform, it's on the main form property sheet

 

[Soegstad]

That helped
Thanks for your help