"Enter Parameter Value" message...

[ineedahelp]

I have been working on trying to get some code to work in an ON CLICK EVENT. I am having trouble with the syntax of an SQL statement. The program was stopped without running to completion many times as I couldn't figure out the error. NOW, I am getting an ENTER PARAMETER VALUE statement for the ON OPEN event of this particular form. Could this form now be corrupted? the error message isn't making sense as I have checked where it could be calling this from. Any tips on how to eliminate this error? Any help will be greatly appreciated!!!!

[ineedahelp]

I deleted the ON OPEN EVENT and recreated it. the problem went away for a bit. After working on the problems I discussed above again, the problem has returned! Eeekkkkk!!!!

[Killer42]

I deleted the ON OPEN EVENT and recreated it. the problem went away for a bit. After working on the problems I discussed above again, the problem has returned! Eeekkkkk!!!!

One thing to check - this can sometimes mean you have mis-spelled a field name or something. Could you show us the code?

[PEB]

Maybe your parameter is concerning a form that isn't open! And you should open it!

:)

[ineedahelp]

The code on my main menu is an ON CLICK event that opens another menu with options:


Private Sub cmbDailyClient_ Click()
DoCmd.OpenForm ("frmDailyClien t")
End Sub

The ON OPEN event on FORM frmDailyClient was:

Private Sub Form_Open(Cance l As Integer)
Me!comboChooseC lient.Visible = False
Me!lstTableList .Visible = False
Me!lstFieldList .Visible = False
End Sub

There are no queries that use the Parameter error statement of :

Forms!frmDailyC lient!comboChoo seClient

I do have other code in AFTER UPDATE events on ON CLICK events associated with the FORM frmDailyClient that do make reference to Forms!frmDailyC lient!comboChoo seClient, but it doesn't make sense that the Parameter Error should arise from the ON OPEN event of this form. Very frustrating to say the least!!

[PEB]

Really i don't see any problems in On Click event procedure

However I suppose that the problem is in the opened form...

In it recordset or in it's combos...

Can you tell us more about...

:)

[Killer42]

...Private Sub cmbDailyClient_ Click()
DoCmd.OpenForm ("frmDailyClien t")
End Sub
The ON OPEN event on FORM frmDailyClient was:
Private Sub Form_Open(Cance l As Integer)
Me!comboChooseC lient.Visible = False
Me!lstTableList .Visible = False
Me!lstFieldList .Visible = False
End Sub

Just taking a stab in the dark here - could it be that the reference to comboChooseClie nt or TableList is causing Access to try to populate it, before you are ready? For a start, I'd try commenting out all the lines in the Open sub, then assuming the error disappears (fingers crossed...) put them back, one by one and see what happens.