Vba. Get series number based on Invoice number (1 Viewer)

[Leonhuynh]

Hi all,

Please help me with the problem:

I have a total of 1000 Invoive No: IV001, IV00A, etc
I have a textbox which allows me to enter Invoice no and another ones to show the result
I want to make a button, when I click on the button, it will find the Invoice no. which I entered and show the record number correspondently in the result textbox

Your help is highly appreciated
Thanks

 

[RuralGuy]

The ComboBox Wizard knows how to search for a value and move the record pointer to that value. Give it a try.

 

[Leonhuynh]

Thanks for ur reply but combo box is not what I am looking for.
I would like to use dlookup + the code or a function that can return the record count.
I can solve the dlookup function but I dont know the function that to return the record count once the Invoice found

 

[Cronk]

What do you mean by "record count"?

You could use Dcount (like Dlookup) to find the number of invoices satisfying your criteria.

If you mean the position of a particular invoice in the table, then that is nonsensical because it depends in the sort order.