One method I used was to have an unbound text box on the "main" form (my forms were all unbound though). This unbound text box would have the record identifier or primary key populated from a listbox. I would then set the subform and sub-subforms underlying queries (the record identifiers) to equal the unbound text box on the main form/subform. Or have another unbound text box in the subform and have the sub-subform's underlying query (record identifier) equal to the subform's unbound text box. (hope that makes sense). This may seem like the long way of doing things but again, I used unbound forms and I could control what got populated in the unbound text boxes via listboxes (or comboboxes). The only form really bound was the sub-subform. Keep in mind that if you have a sub-subform, your subform will not be able to be continuous. There are some tricks to get around this though utilizing listboxes on the forms/subforms. If done correctly, you can make it seem pretty seamless.
Last edited by pkstormy; 08-01-06 at 17:15.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)