Min in Default Value

[The Archn00b]

Hi everyone.

Expressions in Access have given me some trouble before. Mainly due to inexperience. I hardly ever work with them. What I am trying to do is make the default value of a form textbox control the minimum value of a field A in a table A.The datatype of Field A is Date.

So far I've got:

=Min([table A].[field A])

In the Default Value of the form's property sheet, but this just returns a blank value. I've had a look in the table and there is no value that is blank in feld A.

can anyone see what is going wrong?

Thanks!

 

[pbaldy]

Try

=DMin("FieldName", "TableName")

 

[The Archn00b]

It seems to go in OK, but I get "#NAME?" in the Text Box

 

[pbaldy]

Double check the spellings. I just tested and it appeared to work fine. I assume you have that in the default value of the textbox.

 

[The Archn00b]

No sorry. Just doesn't seem to work. I've checked the spellings. The table that I'm querying doesn't have to be open does it?

 

[pbaldy]

No, it doesn't. Can you post the db here?