Strange One

Results 1 to 2 of 2

Thread: Strange One

  1. #1
    Join Date
    Dec 1969

    Default Strange One

    I have a simple select statement shown here.<BR><BR>SELECT MainMenu.NameOnMenu, SubMenu.* FROM MainMenu INNER JOIN SubMenu ON MainMenu.MainMenuID = SubMenu.MainMenuID WHERE subMenu.MainMenuID = "&MainMenuID&" ORDER BY subMenu.MenuOrder<BR><BR>Now this query works fine when tested in access, however when i try to request RS("MainMenu.NameOnMenu") it throws an error saying that the name or ordinal cannot be found in the corresponding collection. <BR><BR>I have no idea why this is failing as it&#039;s such a simple query.<BR>I am i making a school boy somewhere along the way???<BR><BR>Cheers

  2. #2
    Join Date
    Dec 1969

    Default Omit table qualification


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts