Recent content by rajamuzammil

It didn't work out mate. Can you add those lines into my code, it would be helpful for me.

WHDOCNO is the last invoice number. There are several sections for each invoice type, section are listed as WHSECID. Is it possible to add statement in vba code in event procedure?

I want it to fetch number base on WHSECID value WHSECID WHTPDOC WHDOCNO 01 INV 50053 02 WINV 64743 03 DCFDOC 2256 03...

Its returning a number incremented by 1 on form load. But i want it to fetch a number from 2nd row of that table Fil03.

I have a form when it loads, it fetches a number and increments the last stored invoice number. UG added Code Tags Private Sub Form_Load() DoCmd.SetWarnings False DoCmd.OpenQuery "GRNDatatmpIni" Me.Refresh Me.Command42.Enabled = False Dim MyDb As Database Dim mFil03 As Recordset...