You can't go to the specified record

[Amour]

I am really new to VBA,

This query was working fine until I tried to add the tblTravel to it. Now I
get a message: "You can't go to the specitied record" I need this table only
to display a processed date, a airfare amount. This is the current SQL
Statements within the query:

SELECT DISTINCTROW tblAttendan.MEET_NUM, tblAttendan.SSN,
tblAttendan.LAST_NAME, tblAttendan.FY, tblAttendan.TRVL_START,
tblAttendan.TRVL_END, tblAttendan.TRVL_CODE, tblAttendan.ATT_START,
tblAttendan.ATT_END, tblAttendan.POSITION, tblAttendan.DAYS,
tblAttendan.PAY_CLASS, tblAttendan.PAY_RATE, tblAttendan.AMT_PAID,
tblAttendan.PAYRL_DATE, tblAttendan.EST_TRVL, tblAttendan.ACT_TRVL,
tblAttendan.TO_APG, tblAttendan.FROM_APG, tblAttendan.INITIAL,
tblAttendan.UDATE, tblAttendan.[Estimated Airfare], tblAttendan.[Estimated
Per Diem], tblAttendan.LAST_NAME AS indexlastname, tblPersonnel.LAST_NAME AS
perslast, tblPersonnel.STATUS, tblPersonnel.CONSL_TYPE,
tblPersonnel.FIRST_NAME, tblPersonnel.APP_DATE, tblPersonnel.ROTAT_DATE,
tblPersonnel.ORIG_DATE, tblPersonnel.CNSL_DATE, tblMeeting.TITLE_NUM,
tblMeeting.FY, tblMeeting.TYPE, tblMeeting.TYPE_CODE, tblMeeting.TITLE_NUM,
tblMeeting.TITLE, tblPersonnel.PAY_RATE AS perspay, tblTravel.Airfare,
tblTravel.DateProcessed, tblAttendan.COMMENTS, tblTravel.DatetoDFAS,
tblTravel.DateRecatASB
FROM tblMeeting INNER JOIN (tblPersonnel INNER JOIN (tblAttendan LEFT JOIN
tblTravel ON tblAttendan.SSN = tblTravel.SSN) ON tblPersonnel.SSN =
tblAttendan.SSN) ON tblMeeting.MEET_NUM = tblAttendan.MEET_NUM
WHERE (((tblAttendan.MEET_NUM)=[forms]![frmMeetings]![meet_num]))
ORDER BY tblAttendan.LAST_NAME, tblAttendan.ATT_START,
tblPersonnel.FIRST_NAME;




Also, I am using a query to display Subtotals and Totals on one form and
would like that same value display on another. In addition I need to store
the total in another table (sorry but that use to be manually inputted but
now is auto)

That SQL Statement is:

SELECT DISTINCTROW tblTravel.*,
NZ([Lodging])+NZ([Taxes])+NZ([Food])+NZ([Parking])+NZ([Mileage])+NZ([Rental])+NZ([Gas])+NZ([Taxi])+NZ([Phone])+NZ([Computer])+NZ([FAX])+NZ([Metro])+NZ([Tips])+NZ([Train]) AS Stotal, NZ([Stotal])+NZ([Airfare]) AS GTotal
FROM tblAttendan LEFT JOIN tblTravel ON (tblAttendan.SSN = tblTravel.SSN)
AND (tblAttendan.MEET_NUM = tblTravel.MEET_NUM);


Thank You for any help....