Requery Checked Checkboxes with Combobox

[krizzyd]

Hello guys,

I want to re-query my subform using the values in my combo box. To be specific, I need an AfterUpdate code that will make the combo box re-query the data to select a certain field where its checkboxes are true, along with the "Volunteer" field associated with it (neglecting other fields other than the combo box value and Volunteer).

Attached is a screenshot if it helps. The values in my combo box correspond with the fields in my subform in datasheet view.

Any help is appreciated!

[aytee111]

Create the SQL for the record source in the AfterUpdate of the combobox and requery the form.

Me.Recordsource="SELECT xxx FROM xxx WHERE " & Me!ComboboxName & "=True;"
Me.Requery

[krizzyd]

Thanks for the reply.

But how do I reference my Employment Type fields when selecting them? I only want to select one at a time depending on the field chosen in the combo box :P

So I have:

Me.RecordSource = "SELECT qry_EmploymentType.Volunteer,qry.EmploymentType.[What do I put here?] FROM qry.EmploymentType WHERE " & Me!ComboboxName & "=True;"
Me.Requery

[aytee111]

I assumed that the Employment Type field name was the same as that displayed in the combobox/heading. Post the SQL of the record source of the form.

[krizzyd]

Yes, the fields in the combo box are the same as the field column names. Not sure what you meant by "record source" but to be more specific, I have a navigation form and a subform (the one I posted a picture of last post), and with the code I'm currently using it gives me the results as shown in the attachment.

My exact SQL Afterupdate code is:

Private Sub cboEmploymentType_AfterUpdate()
Me.form_Empt.Form.RecordSource = "Select qry_EmploymentType.Volunteer,qry_EmploymentType.['" & Me.cboEmploymentType & "'] from qry_EmploymentType where '" & Me.cboEmploymentType & "' =True;"
Me.form_Empt.Form.Requery
End Sub

Please let me know if this makes sense.

EDIT: The name of the Navigation form is "Navigation Form", the subform is called "Employment Type" and within "Employment Type" there's another form (created from qry_EmploymentType) called "form_Empt". Hope this information helps.

[aytee111]

Yes, the fields in the combo box are the same as the field column names

That cannot be true - otherwise you would not be getting that error that is show above.

Not sure what you meant by "record source"

When you are in design view and you show the property sheet, this property tells you where the data is coming from. What is the name of the form shown here, the one with the actual rows of data? And what is its record source - is it qry_EmploymentType? Bottom line, the record source for the form showing the data will tell us the names of the checkbox fields, then we can make a new SQL statement dependent on your entry.