using a form to update 1 field of a record and add a associated da

A

arran1180

Hi,

Currently i have a form (with subform) that allows you to select a "client"
from a drop down and then displays in the subform all the associated
"invoices." i need a way so a user can lookup the invoices in this way (got
this but working!) and then be able to amend a "status" field in the subform
for each record (eg change from outstanding to paid) and store the results,
as well as automatically filling in a field for when the record was last
updated.

Have been trying, but currently the form will not allow you to make any
changes. It is based on a query, and i''ve made sure all the proprty boxes
are set to "allow edits" and such

really really appreciate any help or pointers!
thx
 
Top