What have you actually adopted of the suggestions made so far?
The impression you give is that you are persisting with storing the date, customer code, invoice sequence number as SalesInvNum and trying to parse that to construct the next number.
The impression you give is that you are persisting with storing the date, customer code, invoice sequence number as SalesInvNum and trying to parse that to construct the next number.
The answer might be difficult but my question was as simple as ABC....
I need to display maximum SalesInvNum in one text box on header form (after selecting a particular customer from a combo. The criteria is the the InvDate (date appeared in yymmdd format) and customercode which are appearing in other 2 textboxes after selecting customer or adding new record to form.
The purpose to do this is my client want to see how many invoices made for this customer in a particular date. Later it will be desided whether to save or not.
This display would help him for certain reason and thats all...I did not thought this will take much postings..
