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

unwanted parameter value box

P: 30
Hi Experts,
I am using a form for lot of info regarding registration. When I press close button, Enter Parameter Value box shows up asking me to put in value for OrgID.Exact wording there is Form!frmGala!intOrgID.
I am still new to VBA and have no clue why is that and what to do to get rid of it.
I appreciate all the help.
Thanks,
Syed
Jan 25 '08 #1
Share this Question
Share on Google+
4 Replies


MindBender77
100+
P: 234
Hi Experts,
I am using a form for lot of info regarding registration. When I press close button, Enter Parameter Value box shows up asking me to put in value for OrgID.Exact wording there is Form!frmGala!intOrgID.
I am still new to VBA and have no clue why is that and what to do to get rid of it.
I appreciate all the help.
Thanks,
Syed
It sounds like the close button runs a query but, when the query is trying to run it can't determine what the OrgID field is.

My suggestion would be to open the form up in design view right click on the button to bring up its properties and view the code in the OnClick event. This should determine which query its trying to run.

I would then view the query in design view and try trouble-shooting it from there.

Hope this points you in the right directions,
JS
Jan 25 '08 #2

missinglinq
Expert 2.5K+
P: 3,532
Mindbender's suggestion about a query running certainly sounds on the money. If the close button you're using is a custom close button, check the code in the button's OnClick event as suggested. If nothing is found there, or if the close button you speak of is the standard Access close button, also look in the code in the Form_BeforeUpdate or Form_Close events as well.

Linq ;0)>
Jan 25 '08 #3

P: 30
Thanks a lot for your reply
Feb 4 '08 #4

P: 1
If the above procedures don't work try these:
launch the Close button's OnClick event and type this before "DoCmd.Close"
command line:"DoCmd.Restore" .
for example:
Private Sub CloseButton_Click()
On Error GoTo Err_CloseButton_Click

DoCmd.Restore
DoCmd.Close


Exit_CloseButton_Click:
Exit Sub

Err_CloseButton_Click:
MsgBox Err.Description
Resume Exit_CloseButton_Click

End Sub
Jul 25 '08 #5

Post your reply

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