Hi everyone. I built a data base with 3 tables, one for client data one for contract info and one for monthly data about each contract.
The start and end date for the contracts in the contract table are in 3/3/1922 format. In the table that holds the monthly data for each contract, there is no date just a month names.
I created a form for the contract data with start and end dates, start up fees, when those start up fees were collected, losses and when those losses were incurred etc. I created a subform for the monthly amount that is used throughout the month. I was able to link these tables by a contract ID no. that is an autonumber in the contract data form. In the monthly amount subform, the contract no. is the same as the one in the contract data mainform. when you open the form you enter data in the mainform then tab to the subform. In the subform you enter data for January then click to next record enter data for February click next record etc. On the subform I set the Contract ID field default value as the value of the contract ID field on the main form. When the main form goes to the next record, the contract ID changes in the subform and you enter monthly data for the new contract.
Now I am trying to create a form to edit the monthly amount form. Everything I've come up with is very confusing for anyone to use. Plus if you make a mistake, you have to go to the tables for the contract and monthly amount and delete all relevant fields and reenter that contract and monthly data all over.
Did I set the tables up wrong or is there actually a way to create an edit form for this?
Sorry for such a long post. I don't know any other way to explain this. Also, right now I'm home and don't have Access so I can't upload anything.
Any suggestions would be helpfull
The start and end date for the contracts in the contract table are in 3/3/1922 format. In the table that holds the monthly data for each contract, there is no date just a month names.
I created a form for the contract data with start and end dates, start up fees, when those start up fees were collected, losses and when those losses were incurred etc. I created a subform for the monthly amount that is used throughout the month. I was able to link these tables by a contract ID no. that is an autonumber in the contract data form. In the monthly amount subform, the contract no. is the same as the one in the contract data mainform. when you open the form you enter data in the mainform then tab to the subform. In the subform you enter data for January then click to next record enter data for February click next record etc. On the subform I set the Contract ID field default value as the value of the contract ID field on the main form. When the main form goes to the next record, the contract ID changes in the subform and you enter monthly data for the new contract.
Now I am trying to create a form to edit the monthly amount form. Everything I've come up with is very confusing for anyone to use. Plus if you make a mistake, you have to go to the tables for the contract and monthly amount and delete all relevant fields and reenter that contract and monthly data all over.
Did I set the tables up wrong or is there actually a way to create an edit form for this?
Sorry for such a long post. I don't know any other way to explain this. Also, right now I'm home and don't have Access so I can't upload anything.
Any suggestions would be helpfull
