Will modifying a Form also modify the underlying code?

[Mike Webb]

I am new to Access 2002. I don't know SQL or code.

Problem: I am trying to modify a form I found at an Access website (Client
and Contact Management sample DB) for our non-profit's use. I tried to
change the SQL I found for RecordSource for the form properties to what we
have in our table, and got an error. Took a look at the underlying code and
didn't see that it was changed after I clicked the Save icon on the toolbar.
Was that because of the error? The error says, "The SELECT statement
includes a reserved word or an argument name that is misspelled or missing,
or the punctuation is incorrect."
I set up the table relationship in the same manner as the sample,
triple-checked the SQL - what am I doing wrong? (I am expecting the SQL
below to "re-do" the form in look & feel; if I am supposed to modify the
design to match the changed SQL, please let me know.)

Here's the SQL:
SELECT tblAddressList.ID, tblAddressList.FirstName, tblAddressList.LastName,
tblAddressList.TitlePrefix, tblAddressList.TitleSuffix,

tblAddressList.NickName, tblAddressList.Organization,
tblAddressList.Address, tblAddressList.City, tblAddressList.State,

tblAddressList.ZipCode, tblAddressList.Email,
tblAddressListCategories.SubCategory_ID,
tblAddressListCategories.SubCategory,

tblAddressListCategories.Description,

FROM tblAddressList

JOIN tblAddressListCategories ON tblAddressList.ID =
tblAddressListCategories.ID



TIA,

Mike

 

[Douglas J. Steele]

One thing I noticed is that you've got a comma after
tblAddressListCategories.Description, before FROM tblAddressList

 

[Mike Webb]

Thanks! Found I needed to add LEFT before the JOIN statement, too. Works.