Hey, all!
I've been working on a form and subform for the last few days. I can't seem to get past the issue I'm going to explain below. Your help is needed!
tbl_Month has only one column - Month. Obviously, the table contains one row for each month. This is the table that corresponds to the main form in my form/subform issue.
The subform is based on a query. It contains the following fields: Community, Accountant, LateFeeStatus, Comments. I've got the form and subform linked on the column Month. So, for every month in the main form, there are several records in the subform.
The columns Community and Accountant in the subform are pre-filled. The user does not need to enter them. However, the user will need to select a status in the LateFeeStatus combobox and enter an optional comment in the Comments textbox.
What I need to do.....
When a user enters records on the subform for one month, I want those values to pass to the next month's records. This sounds a bit like Default Value attribute, huh? Keep in mind, the columns Community and Accountant are already pre-filled for each months set of records. The user will just select a LateFeeStatus and enter Comments. This sounds more like an Update than an Append. What do you think?
All ideas are welcome!
Thanks for your help!
Sheetserr
I've been working on a form and subform for the last few days. I can't seem to get past the issue I'm going to explain below. Your help is needed!
tbl_Month has only one column - Month. Obviously, the table contains one row for each month. This is the table that corresponds to the main form in my form/subform issue.
The subform is based on a query. It contains the following fields: Community, Accountant, LateFeeStatus, Comments. I've got the form and subform linked on the column Month. So, for every month in the main form, there are several records in the subform.
The columns Community and Accountant in the subform are pre-filled. The user does not need to enter them. However, the user will need to select a status in the LateFeeStatus combobox and enter an optional comment in the Comments textbox.
What I need to do.....
When a user enters records on the subform for one month, I want those values to pass to the next month's records. This sounds a bit like Default Value attribute, huh? Keep in mind, the columns Community and Accountant are already pre-filled for each months set of records. The user will just select a LateFeeStatus and enter Comments. This sounds more like an Update than an Append. What do you think?
All ideas are welcome!
Thanks for your help!
Sheetserr