Advise not to use spaces nor punctuation/special characters in naming convention. [Membership #] would be better as MemberNum.
Why are MembersTbl and MasterListTbl not one table?
Deposit amount should be calculated as a Sum of related payment transactions, not saved into table.
DepositSlipQry has a fixed date criteria. This should be supplied dynamically by reference to a form control.
Users should not review data via tables and queries, only interact with forms and reports.
It would be easiest if payments are attached to a deposit ID when payments are entered. This would be done with a form/subform arrangement. Create deposit record on main form and payment records in subform. Master/Child Links properties will automatically save DepositID into payment record. As is, user needs to create Deposit record then code runs an UPDATE action to save the generated DepositID into records using same filter criteria as used in DepositSlipQry.