Just an FYI.....
fields are: ID, Name, Description, Color, Size
"Name", "Description" & "Size" are reserved words in Access and shouldn't be used for object names. Plus they are not very descriptive.
"Name" of what? If a persons name, you should have something link "FName", "LName".
"Description" of what? Note that "Desc" is also a reserved word.
"Size" of what?
Also note that "ID" is a poor object name. It gets confusing (Access too) to have "ID" in every table.
Have to ask: "Color" of what?
Usually using two words (NO spaces) eliminates reserved words and is descriptive.
Examples
"Description" --> "EventDesc" or "EventDescription".
"Color" -->"ItemColor" or "ColorOption".
HTH
-----
Steve
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)