Subform problem

[aporkalypse_now]

First off, I want to thank all of you for your help as you have been great!


I have a subform used for entering line items etc resident on my main form for requisistions.

I have linked a child field in my subform lets call it "request number" to a text box on my main form called "call number" So when I enter my call number in on the main form it pops up under each record in the field "requests" in my subform. The problem I am running into, is that when I have a purchase order with multiple line items, it is creating extra records --basically for each line item, a whole new record on the main form is created. How do I fix this problem ?

 

[Pat Hartman]

If your main form is based on a query that includes the table that the subform is based on, remove that table from the query.