I Have 4 Columns Table To Define Accounts Info
Col. A Account Name
Col. B Account Code ( Number )
Col. C Account Type ( If Main Or Nominal Account )
Col. D Account Parent
I Use Form To Add New Accounts Info With Combobox To Define/Chose
Account Parent & Other 3 Textbox For Same Other Account Info , What
I Need Is To Have ( Max Account Number + 1 ) From Account Group
Numbers In Account Number Textbox As Suggested New Account Number
When I Define In Combobox1 Account Parent , So What Suggested Userform
Code To Manage This Task .
As Example Suppose That I Add New Expenses Account To Operating
Expenses As Main Or Parent Account To These Accounts Category Such As
General Maintenance Expenses And The Last Account Number Added To That
Category Is 41210008 So I Have To Get In Account Number Textbox
41210009 As Suggested New Account Number .
Any Help Advance Appreciated .