Listbox group query row source only show mainform id

[Ruegen]

I have a main form with areas and their id



it's a continuous form.

I have a listbox which shows much the same thing however the row source is showing a query that is grouped with totals. I need to only show the id of the same area.

I thought having areaID with a where "forms!frmSchoolAreasClear!AreaID" in the group would work to only show the results that areaid from the mainform

Is this possible? to have the listbox on each continous form to show only what the same ID?

[June7]

Not sure I understand. You want a listbox RowSource to be dependent on the AreaID of current record so it will show only records with that AreaID? The RowSource is an aggregate query? The filtered RowSource would be a single item?

[Ruegen]

Not sure I understand. You want a listbox RowSource to be dependent on the AreaID of current record so it will show only records with that AreaID? The RowSource is an aggregate query? The filtered RowSource would be a single item?

Yes you have it - I wonder if this is possible. I can get the area to "select" what is in the list but I just want to show instead.

[June7]

If I do understand correctly what you want, yes - it works for me.

[Ruegen]

If I do understand correctly what you want, yes - it works for me.

How do I go about getting it to work? I figured the where would give me the result but it shows up blank.

[Ruegen]

Nevermind I used a dcount on an unbound text box to get the same result (which is better anyway.... )

Now I have to make it so any check box on a continuous form that is checked gets cleared - I'm hoping I can do that on the mainform without having to have a subform/datasheet.

[June7]

Are those checkboxes bound to a field? Won't work with unbound checkbox - checkbox will have the same value.

[Ruegen]

Are those checkboxes bound to a field? Won't work with unbound checkbox - checkbox will have the same value.

They're bound to the area table field "CheckToClear".

I was thinking of using some code I found:

Function TickOnOff(FormName As String, FieldName As String, TickBoxName As String)Dim RecordSourceName As String
Dim Switch1 As String
Dim MySql As String
RecordSourceName = Forms(FormName).RecordSource
Switch1 = Forms(FormName).Controls(TickBoxName).Value
MySql = "UPDATE " + RecordSourceName + " SET " + RecordSourceName + "." + FieldName + " = " + Switch1 + ";"
DoCmd.SetWarnings False
DoCmd.RunSQL MySql
DoCmd.SetWarnings True
Forms(FormName).Controls(TickBoxName).Requery
End Function

If I exchange the fields for mine, and the forms for mine as well as the criteria for the update. Really I want to clear the date field in the tblSchools that correlate with the same AreaID that is in the areas table (the main form with the checkboxes).

[June7]

The form RecordSource is a table or query object, not an SQL statement?

Maybe:

Function TickOnOff(FormName As String, FieldName As String, TickBoxName As String)
Dim RecordSourceName As String Dim Switch1 As String Dim MySql As String RecordSourceName = Forms(FormName).RecordSource Switch1 = Forms(FormName).Controls(TickBoxName).Value MySql = "UPDATE " & RecordSourceName & " SET " & RecordSourceName & "." & FieldName & " = " & Switch1 & " WHERE checkfield = True;" CurrentDb.Execute MySql
'do you need to reset all checkboxes back to False?
CurrentDB.Execute "UPDATE " & RecordSourceName & " SET checkfield=False" Forms(FormName).Controls(TickBoxName).Requery End Function