By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

"Enter Parameter Value" message...

P: 98
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!!!!
Oct 30 '06 #1
Share this Question
Share on Google+
6 Replies


P: 98
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!!!!
Oct 30 '06 #2

Expert 5K+
P: 8,434
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?
Oct 30 '06 #3

PEB
Expert 100+
P: 1,418
PEB
Maybe your parameter is concerning a form that isn't open! And you should open it!

:)
Oct 31 '06 #4

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


Private Sub cmbDailyClient_Click()
DoCmd.OpenForm ("frmDailyClient")
End Sub

The ON OPEN event on FORM frmDailyClient was:

Private Sub Form_Open(Cancel As Integer)
Me!comboChooseClient.Visible = False
Me!lstTableList.Visible = False
Me!lstFieldList.Visible = False
End Sub

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

Forms!frmDailyClient!comboChooseClient

I do have other code in AFTER UPDATE events on ON CLICK events associated with the FORM frmDailyClient that do make reference to Forms!frmDailyClient!comboChooseClient, 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!!
Oct 31 '06 #5

PEB
Expert 100+
P: 1,418
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...

:)
Nov 4 '06 #6

Expert 5K+
P: 8,434
...Private Sub cmbDailyClient_Click()
DoCmd.OpenForm ("frmDailyClient")
End Sub
The ON OPEN event on FORM frmDailyClient was:
Private Sub Form_Open(Cancel As Integer)
Me!comboChooseClient.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 comboChooseClient 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.
Nov 5 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.