Solved The Invoice number will be given depending on status is selected (1 Viewer)

Rania01

Member
Local time
Today, 22:23
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: 149
  • Invoice DB.zip
    138.8 KB · Views: 131
  • Invoice DB.accdb
    1.3 MB · Views: 145

theDBguy

I’m here to help
Staff member
Local time
Today, 14:23
Joined
Oct 29, 2018
Messages
21,358
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.
 

Rania01

Member
Local time
Today, 22:23
Joined
Oct 9, 2021
Messages
59
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
 

Rania01

Member
Local time
Today, 22:23
Joined
Oct 9, 2021
Messages
59
I use ms access 2019, which ms access version are you using
 

Gasman

Enthusiastic Amateur
Local time
Today, 21:23
Joined
Sep 21, 2011
Messages
14,047
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?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 05:23
Joined
May 7, 2009
Messages
19,169
check and test.
 

Attachments

  • Invoice DB.accdb
    2.1 MB · Views: 149

Users who are viewing this thread

Top Bottom