Recent content by rsearing

Figured it out. Basically - the filter was also calculating dates. Although I now had parentId's - in the case of Mark - I didn't ahve a date - so I changed my WhereClause to include date returns with NULL.

Fixed link - it's now a zip file at: www.kofc1913.org/daycare.zip

I am new - please go easy - and very confused why this isn't working. I have a report that works great when I click on the report "New Parents Billing" It shows both parents - and all their children (it's a daycare center app). The problem is - when I run the report from the form I created...

I have been doing quite a bit of research - but nothing that quite answers this question completely - or in a way I can understand (bit of a novice). I am using MS Access 2007 to create an app for my wife who is running 2003. I had the .mdb split so tables are seperate from forms. What I...

Here goes:

Thank you for the suggestion - however, that didn't work. It displays the #deleted after the requery I believe - just not sure....

Ok - I am a novice - and am sure this has to do something with recordsets - or how the data is being populated...but I am having the hardest time removing a "parent" from my form. I have 3 others tables that a parent has connections to - a child table, childhours and totalcharges table. I am...