Order of selecting combo boxes 1

[BrianLe]

In AC97, I have frmTaskCompletion that has cbxOperator, cbxTask, and tbxLastOpertorTask. The record source for tbxLastOperatorTask uses the DMax function. When I select an Opertor and then a Task, the tbxLastOperatorTask updates with the correct "CompletionDate". However, when I select a Task and then an Operator, the tbxLastOperatorTask is blank.

The record source for tbxLastOperatorTask is:

=DMax("[CompletionDate]","qryTaskByDate","[OperatorID] = [cbxOperator] And [TaskID] =" & [cbxTask])

Do you know why it depends on the order the combo boxes value are selected?

Thanks,

Brian

 

[PHV]

=DMax("[CompletionDate]","qryTaskByDate","[OperatorID]=" & [cbxOperator] & " And [TaskID]=" & [cbxTask])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BrianLe]

That did it. Is there a good reference for the correct use of ", ', &?

Thanks

Brian