Continuous subform

lipin

Registered User.
Local time
Today, 19:21
Joined
May 21, 2002
Messages
149
I have a main form with a subform on it. The subform is in Continuous form view so that I can enter multiple records.
But when I fill out some textboxes in the first one it populates the same info in the second one. And then when I go to enter the second record on the subform and overwrite what it populated it changes it in the first record. What's going on??
 
I believe it has to do with the query that you have built for the subform. Run the query for your subform by itself and note any duplicate records that you may have. You may need to change the query parameters due to a one to many relationship.

Can you provide more detail on the query running the subform?
 
I am not using a query with this subform. It is for data input because I need to enter multiple instances for 1 instance occuring in the main form.
 
Check the Control Source Property

L,

Is the "self-propagating" text box bound to a field in the table that "feeds" the subform?

If not, as an unbound text box, it displays whatever it contains in every form "line" that represents a record.

Regards,
Tim
 

Users who are viewing this thread

Back
Top Bottom