still need help

[ppoole16]

I'd like to thank Wayne for his previous help, but I think I need to better explain my problem.

I have a form with a subform. I need to design a query to open a report that will display only the current form and subform. I've been able to display the current form, but all subforms are displayed. The forms are linked by a the field [Number]. And each subform will have a unique date.

I've included a watered down example of my database.

Thanks for the help.

 

[WayneRyan]

ppoole,

You can't name your fields "Date" and "Number", those are
reserved for use by Access. I changed them and removed
the date from the key.

Wayne

 

[ppoole16]

Thanks for the advice. My actual database uses different names, I just used those as examples. What I need help with is getting only the current form and current subform to display in a report. The two forms are linked by a field named "Booking Sheet Number". The unique field on the subform is "Date of Arrest" There is currently no key defined for the subform.

I'd post an actual copy of it but it's on a different computer and too large to transfer by disk.

Thanks for any help.

 

[WayneRyan]

ppoole,

Hey, what a coincidence! That's what the enclosure to my last
post does.

Wayne