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 "f_calculate bill" It's *supposed* to work so that if you don't click on a parent from the dropdown - it will query all parents - or if you click on a specific parent and "view report" - it will choose that individual. Problem is when I click on "Mark Sutton" - he doesn't show up - not even his ID - however, the query that the report is based upon ("query4") does show the record (id is 2).
I have uploaded the 2 database files at:
ftp://www.kofc1913.org/GregoryDayCare.mdb
ftp://www.kofc1913.org/GregoryDayCare_be.mdb
I am thoroughly confused - please help.
Sincerely,
Rob