Query Problem

[Swinton]

I'm trying to make a report based on the current record information displayed in a form. The form includes a sub-form There are two tables which the main form and sub form are based on. Both the main form and the sub-form have independent sequential numbers i.e. RN: 4596 (Main) SN: 1, 2, 3, 4..(subform). I'm trying to extract (via a query) say RN: 4596 and its sub-number 3 but what I actually get is and all of the sub records when I just want RN:4596 & SN: 3 only.
I’m not sure how to structure a query (s) to do this ?

[Access_Blaster]

I'm trying to make a report based on the current record information displayed in a form.

See if this helps.

http://allenbrowne.com/casu-15.html