SQL INSERT INTO

consider the following SQL statement:

INSERT INTO tblConferenceFormsDetails([ConferenceTypeID], [FormName]) VALUES(SELECT Max(ConferenceTypeID) AS MaxID FROM [tblConferenceTypeLookup], 'IEP Service Goal Form W-1');

is it not possible, when wanting to insert a single record, to imbed a SELECT statement within the VALUES argument of the INSERT INTO? i want to append one record. my second value is a string, and my 1st (the SQL) will return only one value... why wont this work???

thanks,
J

INSERT INTO tblConferenceFormsDetails([ConferenceTypeID], [FormName])
SELECT Max(ConferenceTypeID) AS MaxID, 'IEP Service Goal Form W-1'
FROM [tblConferenceTypeLookup];


--
Doug Steele, Microsoft Access MVP
<a style='text-decoration: underline;' href="http://I.Am/DougSteele" target="_blank">http://I.Am/DougSteele</a>
(No private e-mails, please)



"Jtyler" <anonymous.RemoveThis@discussions.microsoft.com> wrote in message
news:65A4827F-EA3F-4366-A4E4-65952E98E28C@microsoft.com...
 > consider the following SQL statement:
 >
 > INSERT INTO tblConferenceFormsDetails([ConferenceTypeID], [FormName])
VALUES(SELECT Max(ConferenceTypeID) AS MaxID FROM [tblConferenceTypeLookup],
'IEP Service Goal Form W-1');
 >
 > is it not possible, when wanting to insert a single record, to imbed a
SELECT statement within the VALUES argument of the INSERT INTO? i want to
append one record. my second value is a string, and my 1st (the SQL) will
return only one value... why wont this work???
 >
 > thanks,
 > J<!-- ~MESSAGE_AFTER~ -->