Dmax

[fiber0pti]

I have 3 Fields. CatID SubCatID and ProdID. In a form I want to know what the last ProdID was for the CatID AND the SubCatID. How do I do this? Do I use Dmax? and how do I use it?
To sum it up I want to look up the highest # in the ProdID field for the CatID and SubCatID. I hope this makes since. I just want it to display it in a text field in a form.

 

[JoeMiller]

Set the RecordSource property of your control equal to the following statement (obviously modify for your environment):

=DMax("[ProdID]","TableWithYourProdIDs","[txtCatID]=[CatID] AND [txtSubCatID]=[SubCatID]&quot

I didn't test this, but I've used similar things before in my forms.

Joe