Hi,
I am recivind "syntax error in from clause" in my access database creating two cascading comboboxs thanks to Mr. alansidman!Here is what I have:
SQL:VBA:![]()
SELECT DISTINCT MaintDBI.Dictionary FROM MaintDBI ORDER BY MaintDBI.Dictionary;
The "Dictionary" dropdown gives the proper results however when I select the "Description" Dropdown I recive the Syntax error.![]()
Private Sub Dictionary_AfterUpdate() On Error Resume Next Description.RowSource = "Select MaintDBI.Description " & _ "FROM MaintDBI" & _ "WHERE MaintDBI.Dictionary = '" & Dictionary.Value & "' " & _ "ORDER BY MaintDBI.Description;" End Sub
Thanks,
Leslye
Bookmarks