.adb code problem

Microsoft provides a template db called Events Management.mdb which I have used for a couple of years with great success. This year the company has decided to make the move to SQL Server so I upgraded my template .mdb to a .adp (Access Data Project). Thinking this would be easy :rofl

IN THE MDB THE REGISTRATION FORM HAS THIS ROWSOURCE:

Code:

---

SELECT DISTINCTROW Registration.*
FROM Attendees INNER JOIN Registration
ON Attendees.AttendeeID = Registration.AttendeeID
WHERE (((Registration.AttendeeID)=[forms]![Attendees]![AttendeeID]));

---

IN THE ADP I HAVE CHANGED THE CODE TO THIS:

Code:

---

SELECT DISTINCT Registration.*
FROM Attendees INNER JOIN Registration
ON Attendees.AttendeeID = Registration.AttendeeID
WHERE (((Registration.AttendeeID)=[forms].[Attendees].[AttendeeID]));

---

AND VOILA IT FAILS! No problem I am new to this transition, please don't shoot me.
It says:
Error in SELECT clause: expression near '.'
Unable to parse query text

I changed the ! to '.' because it didn't like the '!' either. Any insight?

Hmm, I'm afraid you'll have to place the value from the form into the recordsource.
Best probably to use in the form's OnOpen event:
me.recordsource = "SELECT DISTINCTROW Registration.*
FROM Attendees INNER JOIN Registration
ON Attendees.AttendeeID = Registration.AttendeeID
WHERE (((Registration.AttendeeID)=" & [forms]![Attendees]![AttendeeID] & "));"

This does however require the "Attendees" form to be open and the field to be filled.

Nic;o)