Solved The Invoice number will be given depending on status is selected

Rania01

Member
Local time
Tomorrow, 00:16
Joined
Oct 9, 2021
Messages
59
Dear All,
I would like When the invoice status is selected approve, an invoice number is given.
Now an invoice number is given with all entered words, do you know how this can be solved


Thank you in advance
 

Attachments

  • Fotos.jpg
    Fotos.jpg
    56.2 KB · Views: 198
  • Invoice DB.zip
    Invoice DB.zip
    138.8 KB · Views: 192
  • Invoice DB.accdb
    Invoice DB.accdb
    1.3 MB · Views: 231
Hi. Unfortunately, I couldn't open your attachment (you have a newer version). Are you using the AfterUpdate event of the Invoice Status combobox? That's where I would check the status selected and then assign an invoice number.
 
Hi. Unfortunately, I couldn't open your attachment (you have a newer version). Are you using the AfterUpdate event of the Invoice Status combobox? That's where I would check the status selected and then assign an invoice number.
I just add accdb file
 
I use ms access 2019, which ms access version are you using
 
O/P is asking for my help via PM again, when I have already stated I only help if I can, via the forum. :(
I only have 2007, so there is no way I can open the db :)
Why post #2 is not the solution I do not know, as that is what I would have tried first?
 

Users who are viewing this thread

Back
Top Bottom