Hello!
I have 2 combo boxes on a form. The user will select an option from the first combo. Combo 1 will requery the second combo box. This event works brilliantly but when the user selects an option from the second combo box Access produces run-time error number 3075, "missing operator".
The error appears to be coming from the event procedure I placed on the AfterUpdate event on the second combo box. Below is the code I used.
DoCmd.ApplyFilter , "CCU_ID = Forms!Application Recall!SelectCCUID"
I also placed "CCU_ID = Forms!Application Recall!SelectCCUID" under the form FILTER properties.
What am I doing wrong? I basically copied this from the Solutions db to a T.
Thanks in advance,
JONP
I have 2 combo boxes on a form. The user will select an option from the first combo. Combo 1 will requery the second combo box. This event works brilliantly but when the user selects an option from the second combo box Access produces run-time error number 3075, "missing operator".
The error appears to be coming from the event procedure I placed on the AfterUpdate event on the second combo box. Below is the code I used.
DoCmd.ApplyFilter , "CCU_ID = Forms!Application Recall!SelectCCUID"
I also placed "CCU_ID = Forms!Application Recall!SelectCCUID" under the form FILTER properties.
What am I doing wrong? I basically copied this from the Solutions db to a T.
Thanks in advance,
JONP