Find DMax based on combo box selection 1

[BrianLe]

In AC97, I have a table TaskLog with fields Operator and Completion Date. I would like the maximum Completion Date to show in a text box on a form for the Operator selected from cbxOperator. I've tried a number of variations of the following for the record source of the textbox but the textbox come up blank.

=DMax("[Completion Date]","TaskLog","[Operator] = '& cbxOperator &'")

Any suggestions?

Thanks,

Brian

 

[RoyVidar]

You could check out the syntax in the help file. Basically, it might look like this

[tt]=DMax("[Completion Date]","TaskLog","[Operator] = '" & cbxOperator & "'")
- or
=DMax("[Completion Date]","TaskLog","[Operator] = """ & cbxOperator & """")
[/tt]

if the field Operator is text, and

[tt]=DMax("[Completion Date]","TaskLog","[Operator] = " & cbxOperator)[/tt]

if it's numeric.

Then, there's also the matter of what information is in the bound column of the combo? Usually, one would expect a numeric - the primary key of the table where you look up thise Operators.


Roy-Vidar

 

[BrianLe]

You're first one did the trick.

Thanks,

Brian