
April 12th, 2005, 03:47 AM
|
|
Registered User
|
|
Join Date: Mar 2005
Posts: 7
Time spent in forums: 4 h 34 m 8 sec
Reputation Power: 0
|
|
saving multiple accounts on forms
Hi
Can anyone give me some help, the problem is I have a database containing 800 records we use a combo box to look up eash record, but I have now been told that I have to keep a record of the amount of money paid on each account ( we dont need to add it up ) these accounts are paid monthly so I need to have 12 fields 1 for money paid out, & 1 for the date of payment. I have tried using form fields linked to a list box but cannot get the data to go into it .
The amount on each account (form) would be different to the others i.e. on account A1234 we might pay £12.00 then £13.00 on the next bill and so on. But on account E4567 we might pay £36.00 then £38.00 and so on.
Any suggestions would be welcome
Thanks
Last edited by paulxmw : April 12th, 2005 at 03:50 AM.
Reason: spelling
|