subform data does not clear

[findlej]

I have the subform Order Details based off a query to add new order details.
It is a subform of the orders form. Yes very predictable. Anyway, when I add
info then go to the next order record, the data in the subform from the first
order remains. Any help?? Thank you

 

[Allen Browne]

1. Open the main form in design view.

2. Right-click the edge of the subform control, and choose Properties.

3. Set the Link Master Fields property to [Order ID] or whatever the field
is called in your main form.

4. Set the Link Child Fields property to [Order ID], or whatever the
matching field is called in your subform.

 

[findlej]

Thank you I will try it out.

1. Open the main form in design view.

2. Right-click the edge of the subform control, and choose Properties.

3. Set the Link Master Fields property to [Order ID] or whatever the field
is called in your main form.

4. Set the Link Child Fields property to [Order ID], or whatever the
matching field is called in your subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have the subform Order Details based off a query to add new order
details.
It is a subform of the orders form. Yes very predictable. Anyway, when I
add
info then go to the next order record, the data in the subform from the
first
order remains. Any help?? Thank you