You can indeed use the DefaultValue property with these expression:
- For the Max value: =DMax("fldDate";"tblRoomAssignment")
- For the Min value: =DMin("fldDate";"tblRoomAssignment")
- For the Count: =DCount("*";"tblRoomAssignment")
When I used a semicolon between the field and table names I received the error:
"The expression you entered contains invalid syntax
You omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks."
So, I changed the semicolon to a comma and it works perfectly.
It's so simple and yet I spent several frustrating hours trying before I consulted this forum.