>Your command seems to have a syntax error, most likely missing brackets. Sergey just gave me another shorter version which worked. All the same thanks for your co-operation.
>
>Fred

No, I missed the semi-colon off the end of a line:

Select * from MyTable ;
  where DateTimeField = csrMax.Max_TF && Here should be ;
  and CustID = lnChosenID

But like I asked Sergey, doesn't that soln. give you a list of different cust_ID vals, as opposed to the actual ONE that you want for the selected ID?