For dates use # around the value. For example:

FieldDate = #" & dbTable1!MyDateField & "#

For boolean you typically use True/False (or 0/−1), no quotes. Fr example:

FieldBool = " & dbTable1!MyBoolField & "

(Access recognizes True/False without quotes)