View original (French)

ACCESS - Indicate the MAX value of a TABLE

Solved
Rafy68 Posted messages 89 Status Member -  
Rafy68 Posted messages 89 Status Member -
Hello,

I would like to know if there is a way to indicate in a form control the MAX value of a column from another table.

So, when the FORM activation event occurs, I want the MAX value of the column DATA from my table T_Parametre to be placed in control ECH2.

Is there a function like

ECH2.Value = ....... ?

Thank you in advance

Rafy68
Configuration: Windows XP Firefox 3.0.4

2 answers

Answer 1 / 2
LatelyGeek Posted messages 1774 Registration date   Status Member Last intervention   550
 
Use the MaxDom("[FieldName]","[TableName]") function or DMax("[FieldName]","[TableName]") if it's in vb.
--
Why complicate life by making it simple, when it's so simple to make it complicated?
0