Solved Data entry creates a new client (1 Viewer)

[dullster]

With a little help from my friend the form is now fixed. A search combo box was added to the header for the Client. The Client Full Name box was recreated as a list box. The Orderby on the main form was removed and Editing on the main form was changed to No. Editing on the SubForm was changed to Yes.

Wanted to let you know the fix. Thanks for all you help.

 

[Mark_]

It just has revenue related to a client by date with receipt number. The revenues are based off taxes received by date or receipt number. There may be other revenues by ex. driveway permit or cemetery payments but those revenues would never be from the same client. The service would described by the UCA code (tblDemoUCAs).

As this is for permits, fees, and the like, is your accounting required to break out when the debt is incurred by the resident as well as when the expense is paid? Are you having to break out the sources?

For example, trash or sewage charge that is periodic, has a date due, and that has to be tracked back to as service may be terminated for non-payment?

The more you can explain about how the current system works (or should work), what your reporting requirements are, and details for what the municipality requires, the better we can answer.