Creatiing a report based on Option groups, queries and parameters

[June7]

That is VBA code to execute an SQL action statement. No Access query object is involved.



It doesn't work because variables must be concatenated. Reference to control on form is a variable. I prefer CurrentDb.Execute method:

CurrentDb.Execute "UPDATE wrkTable SET Chosen=True WHERE Department = '" & Forms!EdEnroll!Department & "'"
Forms!EdEnroll.Requery

If Department is a number field, remove the apostrophe delimiters.

Run Debug>Compile to catch VBA code syntax errors but it will not catch errors in SQL statements.

[Canadiangal]

Thank you very much for your help!

[Canadiangal]

June, I just noticed that my on combo field is cutting off the data. So I have an unbound field called combo 19. I have four fields that have the following values:
=[combo19.[Column(1)]
=[combo19.[Column(2)]
=[combo19.[Column(3)]
=[combo19.[Column(4)]

My =[combo19.[Column(4)] pulls from the query based on combo 19 which is my notes field. In the query, the data is all there. However, when I pull column 4 it cuts off the data. Any work around for this?

[June7]

Notes field is memo type? Combos truncate memo field type data.

One way to handle might be a subform.

I would have to know more about data and form structure.