DMAX function where clause 1

[RandDUser]

I have a DMAX function where I need 'XX' = me.textbox1.value:

DMax("[Year]", "tbl_MAIN", "XX")

I tried: DMax("[Year]", "tbl_MAIN", me.textbox1.value), but produces a run time error. I'm sure it's something simple, but I can't figure it out.

Thank you!

 

[AlexCuse]

YOur criteria needs to be

"SomeColumn = " & me.textbox1.Value

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[RandDUser]

OK, I tried the above:

DMax("[Year]", "tbl_MAIN", "Quantity = " & me.textbox1.Value)

And I got a runtime error 2001. Not sure if I have the syntax right.

 

[AlexCuse]

Ah, it's quantity. Number needs to = number. Try this:

DMax("[Year]", "tbl_MAIN", "Quantity = " & val(me.textbox1.Value))

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[RandDUser]

That did the trick, thanks!