data on subform is carried over from previous record when a new record is added

[bkberg05]

Hi -I have a form which contains a sub-form. The sub-form is tied to the main form by a shared field called Project_ID. The main form has one record per Project. The sub-form has many records per Project.

When I'm adding Project records and go to a new record, the sub-form has no data in it. But then as soon as I type any data into the first field on the main form (after I type in the first character), the sub-form appears to populate itself with the data from the previous record. When I tab into the sub-form, this carryover data disappears (it's never stored in the new record, it just appears there temporarily until the subform gets focus.

It's bizzare behaviour and I can't figure out how to make it stop. I tried requerying the subform and setting the focus to it and moving the focus away (both on the On Current and On Dirty actions of the main form), but those don't work.

Thanks in advance for anyone's help.

Bill

[NeoPa]

I don't know Bill. Perhaps it may be version specific. Why not post which you're using and see if anyone recognises it. We do have experts here who are very experienced with forms & subforms and stuff.