Form Problem

[Barry Stow]

Ms Access 2003
I have created a membership database which includes a form to record payments of dues. The Payments Form has a main Form and three sub-Forms as follows;

Main Form" frmPayments", not linked, Contains search box to locate a members details in tblMembers
Sub Form " sub_frmMmbersDetails" linked to tblMembers, Displays selected members details
Sub Form "sub_frmPayments" linked to tblPayments, Allows entry of payment data

On selection of a Member and entry of a payment I want to be able to Save the payment details to tblPayments (and any changes that may be made to correct a members record to tblMembers), and proceed to select another member and enter another payment. I have set up three command buttons to Close the Main form (DoCmd Save)and Save the data and Close (DoCmd.Save & DoCmd.Close), and Cancel without saving.

I have created the forms and can select a Member, display the membership data and allow the Payment data entry, however I can’t make the two save buttons work.

Any help would be most appreciated.

 

[dstone10]

Is the subform sub_frmpayments bound to tblpayments?

If not that form, which form would they be typing data into that you want saved to tblpayments?

Are the fields on the form in the record source of the form?

If all of that is true then would you mind posting the code from the click event of the button(s)?

Thanks!

 

[Barry Stow]

Many thanks that set the mind racing and I figured out that the Forms were bound to Queries, once fixed the code worked well.
Now I have a problem with the DoCmd.Close command I wish to give the option to Save and Close or just Close. I ca'nt get the acCloseSaveNo or acClosePrompt commands to work.
BarryS