?? on DMAX function

[eliotchs]

Hi

Can anyone let me know why this is stating an ERROR in the textbox when I run the form ?

I am using this formula as the default

=DMax("[SEQ]","HillData","[CLINO] =" & [Forms]![EpisodeNotes]![CLINO])

where Hilldata is the table
and CLINO is the field on the form EpisodeNotes

Thanks
Joe

[orange]

Is CLINO text or number?

[eliotchs]

Clino is text on this db where the db I got the formula it was a number

[John_G]

It might be because there are no records in HillData for that particular CLINO, and DMax returns Null, which the underlying table doesn't like. Use Nz to return 0 in this case:

=Nz(DMax("[SEQ]","HillData","[CLINO] =" & [Forms]![EpisodeNotes]![CLINO]), 0)

John

[orange]

I think you'll need these quotes if it is text
=Nz(DMax("[SEQ]","HillData","[CLINO] ='" & [Forms]![EpisodeNotes]![CLINO]), 0) &"'"