Form called Input Allotments that shows the current funds of one Description_location.
Subform that shows all the records associated with the Description_Location: master_data_auto_fiscal_year_subform based on a Query.
Query: Master_Data_auto_fiscal_year it has all the fields from the MasterData table
There is a field called DOC_NO this is a number that goes up +1 as a new record is added to the set based on Form: Input Allotments field Description_Location.
How can i get the Subform based on a Query with the Field name Doc_NO to auto fill based on last Doc_No within the same Description_location
This is the subform based on Query
<tbody>
</tbody>
Subform that shows all the records associated with the Description_Location: master_data_auto_fiscal_year_subform based on a Query.
Query: Master_Data_auto_fiscal_year it has all the fields from the MasterData table
There is a field called DOC_NO this is a number that goes up +1 as a new record is added to the set based on Form: Input Allotments field Description_Location.
How can i get the Subform based on a Query with the Field name Doc_NO to auto fill based on last Doc_No within the same Description_location
This is the subform based on Query
DOC_NO | Description_Location | Allotments |
1 | RD - Salaries and Expenses - 2019 | $50,701.14 |
2 | RD - Salaries and Expenses - 2019 | $73,933.69 |
??? | RD - Salaries and Expenses - 2019 | $378,179.73 |
<tbody>
</tbody>