Hi everyone,
I seem to be in quite a delimma. when I make a recordset and test it DW
returns all the correct records but when I upload the page I get the No
Record error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.

Here's the SQL:

SELECT *
FROM my_groups INNER JOIN contact ON my_groups.secondary_ID = contact.ID
WHERE my_groups.primary_ID = MMColParam AND my_groups.group_ID = MMColParam2
AND my_groups.group_response = MMColParam3
ORDER BY usrid ASC

MMColParam = session(MM_Username)
MMColParam2 = family
MMColParam3 = yes

Yes some parameters rely on sessions but so do other things on the page that
are working correctly.

Someone please help before I go completely mad.
Thanks for any advice in advance.

Jeremy

Maybe quotes are needed around MMColParam in sql statement. Can you
temporarily print the sql statement on your web page to check it?