Combox Boxes not changing values 1

[CGSB]

Hi, I have two combo boxes on my form whose value cannot be changed. If I copy these boxes to another form, they work! If I take a working combo box from another form, and insert into this form, it no longer works.

I think the problem might be with my SQL query. However, if I open the query outside the form (in datasheet view), the combo box works fine.

Here is my query:

SELECT [course].[course_name], [candidate_course].[status] AS status, [candidate_course].[year], [candidate_course].[quarter], [candidate_course].[file_no]
FROM course LEFT JOIN candidate_course ON [course].[course_id]=[candidate_course].[course_id]
WHERE ((([course].[set])="1") And (([course].[target])<>'cfsm') And (([course].[active])=-1) And (([course].[mandatory])=0));

Status and Quarter have text data types and use combo boxes as their display control in the Lookup tab.

Please help!

 

[CGSB]

Here's so more information, just in case it might help.

The combo box is set to drop down.

To test it, I took a functional combo box from my other forms and put it on this problematic form, and I still couldn't change the value.

I think the problem might be with my SQL statement, but like I said, when I open the query, I can change the value and it gets stored in my "candidate_course" value. But when I use the form, I can't change the selected value (eg. It is set to "Yes", and I cannot change the selected value to "No" or "Pending").

I'm sorry if this sounds a little vague, just let me know if you need further explaination.

Thanks!

 

[VicRauch]

You form is more than likely set to (under the Data tab in Properties) "AllowEdits" No

Change that to Yes, and you can change things on this form.