Question Help with a DMax Function

[josephbupe]

Hi,
I created an application to help in tracking cases at the office. Most of the stuff is appreciated except users were required to input record count (Case Folio) manually each time they open a new case. I realise I needed to include a DMax Function to automate creating a "Case Folio" but I have no idea how to go about it.

I prefer that when the user types/fills in any of the text boxes in the subform (eg CaseName) the DMax value should be generated in the field "Case_Folio". Please, how would my function look like?

There two tables like this:

tblFiles
FileID=PK
............................

tblCases
CaseID=PK
FileNo=FK
Case_Folio=number
CaseName

I will appreciate any help.
Joseph

 

[John Big Booty]

Check the sample posted here it should help you out.