Dear friends,

I have trouble seeing the related records on two different forms. For example, I entered the info on the first form as record #2, which is related to the info on the second form (another word, second form is the continuation of the first form . However, when I click to see the second form, the second form is still on rec #1 (which is wrong record and I want it to be shown as #2). How do I fix this?

Thank you so so much. L

Do you have two independent forms or do you have a main form / subform situation?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thank you SerranoG.

I created two different program in two different ways, just in case. One with independent forms and one with subforms. I m interested in the one with independent forms. However, could you please advise on both ways if possible.

Isn't that on subform, we have to create a main table for the main form, then the other tables for the subforms and link them by record source? I think that's how we do it but I'm not sure.

L. Quality Engineer (I didn't know you work for Quality also)

For independent forms, you open the second form based on the current record of the first form similar to this (use your REAL names for things; I'm making names up):

DoCmd.OpenForm "MyForm2", acNormal, , "[lngRecNo] = " & Me.txtRecNo

Where I'm opening the second form based on the value of the field lngRecNo. This assumes that both forms have tables that each have a field called lngRecNo. Each will also have a textbox called txtRecNo that is bound to each's lngRecNo.

For a form/subform situation, you just have to place a subform in the main form and relate the parent/child properties of the subform to lngRecNo from both forms.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division