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:
SELECT DISTINCT MaintDBI.Dictionary
FROM MaintDBI
ORDER BY MaintDBI.Dictionary;
VBA:
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
The "Dictionary" dropdown gives the proper results however when I select the "Description" Dropdown I recive the Syntax error.
Thanks,
Leslye
Bookmarks