unwanted parameter value box

Quote: Originally Posted by razjafry 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

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)>

Thanks a lot for your reply

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