Lookup Table

[Nylex]

I know how to look up a max number if I have the Table opened but how do I
find an answer if the table is not opened
Table Name “WorkOrders†Field with no in it “InvNoâ€
Is it possible

 

[Rick Brandt]

I know how to look up a max number if I have the Table opened but how
do I find an answer if the table is not opened
Table Name "WorkOrders" Field with no in it "InvNo"
Is it possible

In code, or in a form/report control expression you can use the
expression...
=DMax("InvNo", "WorkOrders")