Can this not be done?

[CJ]

Hi Groupies

I had an extensive thread about this on March 25 with Jeff Boyce but we
never did get this resolved. Perhaps it can't be done?!?! If you want to
check all the gory details, the thread is Repost: Saved record on other
form. In a nutshell, this is the situation:

I have a main form frmDailyMain (parent). On it is fsubBlockTU (child). On
fsubBlockTU are fsubDailyBoxes and fsubEmpPay (Grandchildren).
fsubDailyBoxes is (and must stay) a continuous subform, so I can not make
fsubEmpPay a Great Grandchild. Relationships are all good, data integrity is
great. The whole database is wonderful except for this one issue.

What I would like to happen is this:

When a record is added to fsubDailyBoxes I would like a check box
(ysnCampCosts) on fsubEmpPay to be selected and the record saved. I don't
want the user to have to physically select the box because they forget.

At the moment when they physically select the check box, the correct
employee and date populates the record and everything is great. But, how do
I get access to think I clicked in the check box without actually having to
do so?

 

[Albert D. Kallal]

If the fsubDailyBoxes record already exists, then you just in fsubDailyBoxes
after update event

go:

me.Parent.fsubEmpPay.form!ysnCampcosts = true

 

[Albert D. Kallal]

If the fsubDailyBoxes record already exists, then you just in
fsubDailyBoxes after update event

Above **should** read:

If the fsubEmpPay record already exists, then you just in fsubDailyBoxes
after update event

 

[CJ]

I KNEW it had to be something simple. I can never get the syntax right for
parents and subs.

Thanks so very very much Albert. Today, you have made a LOT of people in
Alberta and BC very happy.

Cheers!!!!