Thread: ERROR: "Query Input must contain atleast one table or query"

Hello,
I am very new to the SQL word and am trying to find out what is wrong with this code. The subquery works on its own but when i put it within this insert query it does not seem to work. Any suggestions?

INSERT INTO t_Audit ( EditDate, [User], SourceTable, FirstName, LastName, ID, DOB )
VALUES (now(), 'Test2', 'Test3',
( 
Select t_Dustin.FirstName 
From t_Dustin 
Where (( t_Dustin.FirstName like "Dustin"))
),
'Test5', '1156', '11/8/1986')

Thanks