subform data does not clear

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thank you I will try it out.

Allen Browne said:
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.

findlej said:
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
Click to expand...
Click to expand...
 
Back
Top