Parameter Value when closing a primary form?

[d9pierce1]

Views: 16 Size: 1.03 MB">ProjectSample.zip

Hi all,
I have a parameter Issue I cannot solve. I have spent 4 days now on this trying to figure it out and have no idea why it is
creating this error on closing the primary form? No Idea at all


So with that, I have toned down a sample db and it will open to the form in question. (frmProject Holder)
When I click the Permit Info Tab, then click the Permit Issuer or Permit Holder Tab and close the main form
I get a parameter value ? Why I dont know... But it is truely driving me nuts! If I could get some assistance with
it that would be great. I have tried making WHERE's in many different types and finally ended up putting in a query
Attached to the list box and combo box in those forms.


The function is once I select a Permit Issuer or Holder from the Combo, it populates the list box with the numbers associated.
Then I can select from a different combo what contact I want associated with it and it populates the Phone and Email for the contact.


All works great except for this anoying parameter value when I close the form
If I am on Permit Doc's tab, form closes fine, just when on two of the other tabs I get the Parameter Value ?
Please help!!!!


Thank you,
Dave

[June7]

Next time you provide a db, please either remove images from forms or provide the jpg's.

Your "tabs" aren't tabs, they are command buttons. You are using a single subform container to load different forms (essentially emulating a Navigation Form). Apparently, something somewhere is referencing form that is no longer loaded. Either modify that code or first reload the missing form into container before closing form.

[Welshgasman]

And it tells you what it is looking for?

I cannot even find just the word ScheduleID in the code?

[d9pierce1]

Hi Welsh
Its not in code, its in a querry & Forms

[Welshgasman]

Well search for it there. I have no idea as to how all this is meant to work, so hard to debug.

[davegri]

This will avoid the errors. I have never seen VBA code with so many Me.Refresh lines.
Commenting these may have unforseen consequences, but here you go...

For sfrmProjectPermitIssuer

Private Sub Form_Current()
    On Error GoTo Error_Handler
If Me.OnLineAccess = True Then
    Me.UserName.Enabled = True
    Me.Password.Enabled = True
    Me.Website.Enabled = True
Else
    Me.UserName.Enabled = False
    Me.Password.Enabled = False
    Me.Website.Enabled = False
End If
''''''''''''''Me.Refresh


Error_Handler_Exit:
    On Error Resume Next

For sfrmProjectPermitHolder

Private Sub Form_Current()


'''''''''''''''Me.Refresh


End Sub

[d9pierce1]

Thanks davegri
I will give that a shot and let you know.
dave

Update
Thanks for all the help!
I found that the refresh was what was causing the problem but without the refresh,
it wouldnt update the list box or combo so I took the error code and refresh out totaly
and put in the primary subform for that subform when I click on the combo, it will call the button
and that refreshes it and gives me the correct info!
Again
Thanks
Dave - Marking as solved