Continuous form not showing data from the underlying query

[msmithtlh]

I have a continuous form based on an underlying query.

The query displays the correct data.

The form uses two cascading combo boxes to make selections, which are working correctly. When I run the query putting those fields from the form in the query criteria, it gives me the expected data.



The form header with the combo boxes is working correctly. The detail portion of the continuous form is all blank

The query is "team members qry"
The form is "team members"

Test values: Congregation: Trinity UMC
Team Leader: Robert Gibbs

Zipped database attached.

Many thanks!!test.zip

[davegri]

You don't need to do the team search; the filter is already applied by the form's recordsource query criteria.

Option Compare Database
Option Explicit


Private Sub cboteam_AfterUpdate()
'    If (Me.cboteam & vbNullString) = vbNullString Then Exit Sub
'    With Me.RecordsetClone
'        .FindFirst "[Team_ID] = " & Me.cboteam
'        If Not .NoMatch Then
'            Me.Bookmark = .Bookmark
'        End If
'    End With
    Me.Requery
End Sub


Private Sub Form_Current()
    'Me.cboCongregation = ""
End Sub


Private Sub cboCongregation_AfterUpdate()
    'Me.cboCongregation.Requery
    Me.Requery
End Sub

[msmithtlh]

Thank you!! That worked. I thought you could add and update records in a continuous form, but this isn't allowing me to add or update. Is there something I can change to allow that?

[davegri]

Thank you!! That worked. I thought you could add and update records in a continuous form, but this isn't allowing me to add or update. Is there something I can change to allow that?

The form will not allow updates or additions because of the underlying query. That query (Team Members qry) is non-updateable because it includes 5 tables.
You'll need to decide what the form actually needs to do and then design a simplified query to accomplish that.

[Micron]

The form will not allow updates or additions because of the underlying query.

That is why I
a) recommend basing forms/reports on queries, not tables (not even single table queries)
b) building query first, then test if suitable. If not, there's no sense in building a form or report based on it then finding out you can't work with it.