This code to get the last number in my table code #

[MohamedAmin]

In this table should be to add items (Category and Sub-Category) so I need when I choose the category and the sub Category will filter the table depending on the sub-category and give me the last number
txtCode for code
comDepartment for category
comSubCategory SubCategory

Private Sub comSubCategory_Change()

End Sub