Hi there Access gurus. I need to concatinate 3 strings to be used with FindFirst with in a form. I have gone throuh the help pages with in Access help but still can't figure out how to do it, your help is appreciated.

The criteria would be as follows
Criteria = [Year]=me!xxxxx, [Month]=me!xxxxx, [Week]=me!xxxxx

to be used for rst.FindFirst Criteria

What i need to do is to find a specific record with in a payroll table that matches the criteria and send a meassage if "rst.no match" is false