Search Multiple Fields and Generate Next Available number

[wrightlefty]

I have three different fields; series, identifier, and partcode (ex. sss-iippp). I want to type in the series and identifier into combo boxes and then click a button that will search the series and identifier fields for all partcodes associated with the inputed data. Then it should find the highest numbered partcode, add 1, combine the 3 fields into one number (format sss-iippp), and place the new number in a field called newpartnum. I'm not sure if this should be done with queries, macros, or just written completely in VB. I would say I am a beginner, so any and all ideas would be welcome. Thanks.

 

[PHV]

Have a look at the DMax function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wrightlefty]

The dmax function will work at the end to find the highest partcode and add 1, but how do I search the series and identifier fields and find only the highest value partcode associated with the inputed data?

 

[PHV]

And what about the 3rd argument of the DMax function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wrightlefty]

Thanks. The DMax worked great. No queries necessary, one line of code did it all. Thanks again.