find record with parameters

[adj]

Hi,
I am trying to use a recordset vairable and find a record using the date parametr passed in from the from. It doesn't seem to like the & before the Forms command or after the enter sequence. Please help.

Anne

Here is the statement I am using.
mytable.FindFirst "EMP = '" & mydata("EMP") & "' And Date = #" "'&Forms![Update].Form![Next_Date] And "# And [Job No] = """ & mydata.[Job No] & """ And [Report Date] = '" & Forms![Update].Form![Next Week] & "'"
If mytable.NoMatch Then
mytable.AddNew