Change values on form that come from query

[szucker1]

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?

[khalid]

Query based form with calculated field are not editable, you can use listbox with the same query on the form and check for the amount where Suggested Amount To Pay need to be changed.
Your form's recordsoure should be bound to the editable table or query, not to the calculated query.

[szucker1]

Khalid - Thank you for your reply. That makes sense to change the form's record source to the 'Check Register' table, but I only seem to be able to add one record at a time. I was hoping to have the Form show multiple (let's say 20) members and their 'Suggested Amount To Pay'. The user could then change some (let's say 5) of the amounts. Then have the Form add all 20 new records (15 with suggested amounts & 5 with changed amounts) to the 'Check Register' table.

Can this be done simply or should I maybe have my query with 'Suggested Amount To Pay' to each 'Member' be converted to a temperary Table, allow the User to veiw and make changes to this temperary Table, then append the temperary Table to the 'Check Register' table, and finish by deleting the temperary table?