Referring to =Max() 1

[merlynsdad]

I have a table with autonumbers (field is ID), and I need to refer to the highest one in code. I want something like intTixNum = Max(tables!tblMaster!ID), but something that works.

If the square peg won't fit in the round hole, sand off the corners.

 

[PWise]

intTixNum = dmax("Fieldname","TableName")