Im so confused of auto incrementing a receipt number format.
example i have a starting receipt no. (00000) in a mysql field called or no.
when the paymentfrm load, the textbox that contains the receipt no will be added by one so that it will become 00001. I try this by getting the last used receipt no, but when i add 1 into it wil not become 00001 bu the result is 1. whats wrong with this. Please help. Im using mysql as my back-end database.
txtreceitno=rs.fields("orno") + 1
Whats wrong with my code.?
God bless on this mother earth.