Getting missing value error when I try to close a form

[bradp1979]

Long story short, I have one form called PPADataOnly. It is related to frmClient. Out of no where, when I select the "close all" command button, I'm getting a popup saying that paramater value for Forms!frmClient!txtClientID is missing, asking me to fill it in.



Here's the code for the close all command button:
Private Sub cmCloseAll_Click()Dim db As Database
Dim frm As Form
Dim intX As Integer




Do While Forms.Count > 0
DoCmd.Close acForm, Forms(0).Name
Loop


DoCmd.OpenForm "frmMainSwitch"
End Sub

This is the popup box I'm getting.

[ranman256]

Either your txtBox is spelled wrong
or
the form name is spelled wrong
or
form is not open.

[bradp1979]

I just figured out the exact circumstances: When frmClient is open and on a record, and I then open up a PPA form and hit close all, then I get the error. If frmClient is NOT open, and I have a PPA open, I get no error when I hit "close all".

[June7]

Are you using dynamic parameterized query as form RecordSource?

I NEVER use them for anything.

Which form is that code behind?

Interesting, would have expected the opposite behavior.

[bradp1979]

The code is behind frmPPA_DataOnly.

I don't think that I'm using dynamic parameterized query as form Record Source. The RecordSource is "SELECT * FROM tblTempPPA_DataOnly ORDER BY DateTimeLastAccess DESC, CompanyName, ClientName, EventDate;"

[June7]

Something somewhere is referencing that form control when it is not available. If you want to provide db for analysis ...

[bradp1979]

This got even weirder. So I started over with an older FE to figure out which of the additions I made was creating the error, and I found it. I have a list box that shows all the events that a particular client has booked with us. I wanted to do a simple count of the events in the list box. The list box is called lboEvent, so I placed a text box beneath it, and inside, I had

"=lboEvent.listcount".

That's what caused the missing parameter popup. I deleted it, and the popup hasn't resurfaced.

I don't get it, the expression in the text box I placed doesn't reference the ClientID at all, but there it is.