I am using Access 2000 and have a Query which calculates an individual 'Suggested Amount To Pay' to each 'Member' of our association. I want to use this Query as default entries to a Form used to add records to the 'Check Register' table which records actual payments to members. I would like the User of the Form to be able review the list of members and their default ('Suggested Amount To Pay') check amount, and, if needed, for a given member change to a different amount. After any individual amounts are changed all check amounts greater than zero are added to the 'Check Register'.
How do I allow the User to change default values on the Form that come from the Query?