Problem with sub forms!

[Dave]

I have a main form that contains a field called GuardianID. I have a
subform in this report that links on the GuardianID field.

The subform is based on a query that shows all invoices and payments that
have a status of unpaid (a yes/no field called allocated) where the
GuradianID is the same that is on the main form.

The purpose of this form is to allocate the payment to invoice. I had
envisaged it by showing all the outstanding invoices and payments and
ticking the yes/no box to allocate the payment. This would then save the
updated status back to the database.

If i run the subform without using a Guardian filter i can amend the yes/no
flag easiliy however as soon as i filter by guardianid if i try and amend
anything, the machine beeps and i can make no alterations.

Any ideas? Is it the query i am running?

TIA

 

[Steve Schapel]

Dave,

I am not sure why you are not able to edit the data in the subform.
Maybe you could post back with the SQL view of the query that the
subform is based on, and someone may see something there. But in the
meantime, you don't need to "filter" or apply any criterion to the
subform's GuardianID. Just set the subform's Link Master Fields and
Link Child Fields properties to GuardianID, and this should take care of
the subform only showing records related to the main form's GuardianID.