Access2000 - use child form field as report criteria

I am creating an application using Access 2000, yuck I know! I have a parent form and child form with fields on it. I want to create a one page report that will show data from the main form and the child form (two different tables). I would like the query criteria to read the content of a field on the child form. I created a query for the report that works fine. Here is the current FROM and WHERE SQL:

FROM tblBasicRCData INNER JOIN tblNoticeChange ON tblBasicRCData.RecordID = tblNoticeChange.RecordID
WHERE (((tblBasicRCData.RCNo)=[Forms]![frmNoticeChange]![RCNo]));


This works fine for the RCNo which is on the main form. What I really is a field located on the child form (tblNoticeChange.ChangeID) that comes from the tblNoticeChange table. I can't make the report run without it asking me for the parameter.

I can't be the first one to try and automate a criteria from a child form. I can make it read data from the main form but not the child form. There must be a simple solution to modify my SQL.

HELP P L E A S E!!!!!

 

I feel ignored. Everyone must be too busy. I looked all over the internet and different books that I have along with the internal Access help and can't find nothing on the subject. I figured this would be something simple.

I looked through your message log and couldn't find anything either. I am getting a bit desprite I need to finish my by 4pm EST on Friday. I can't afford a major redesign at this point for one stupid field.

Pretty P L E A S E!!!

 

your child form is pulling this table?
tblNoticeChange

if yes, then make sure you include the tblNoticeChange.ChangeID on the child form as well. You can hide the field on the form and simply reference the field in your query.