Unwanted parameter message
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I am trying to open a form and now it keeps asking me for a parameter value:
Service.[Service_ID]. The thing is I have no idea where, in the code, Access is looking for this value.
It seems to be doing this prior to the onset of my form load& before any form events happen (e.g., when I walk through the code, the parameter popup appears before any of these events are kicked off: Open Load Resize Activate Current). Prior to any these aformentioned events kicking off, I make attempts to open a form like so:
DoCmd.OpenForm "00160_Clone_Service_Level_Contacts", acNormal, , , acFormAdd, , strArgs
As soon as I step through the DoCmd.OpenForm line, a message box pops up asking for the parameter value, shown previously: Service.[Service_ID].
So, its looking for Service_ID from the service table, but the form is unbound. So when does it check for this value? And how can I stop it from doing this
In more detail:
I created a query where I have a pop up parameter box that asks for the start date and another asking for the end date. The parameter is written in the criteria as follows:
Between [start date mm/dd/y] and [end date mm/dd/y]
When I run the query, the parameter query works beautifully.
So then, I ran a crosstab query based on the (first) parameter query hoping that it would pull the parameter query forward, but it didn't, I got the error message instead.
but if I set the code for two parameter values the mean second form it works but it gives another message that like form open action was canceled.
Is there such a procedure for providing a message box when the teacher enters a class into a parameter query and the form is empty?
I would like to display a message box that informs the teacher that the class does not exist rather than load a blank form.
How I can put the parameter value directly from the form, without dealing with the message box report asking me the parameter value again?
The result should display: "Old account with more than [Parameter_value(from the form, not the query)] days"
Note: The form closed once it display the report.
Build Date______ Weeks Left: DateDiff("w",Now(),[Build Date]) ______ Priority: IIf([Weeks Left]>7,"Low",IIf([Weeks Left]>3,"Medium","High"))
These are the different columns in my query design, and every time I run it, it always ask for a Weeks Left Parameter Value. Although if I just click OK on the box, the query will still show the correct output. The dialogue box just annoys me a lot though. I checked the spellings and they are all the same. Anyone can help me out
I tried using DoCmd.RunSQL, but, if I understand correctly, this can't be used for a select statement. I used it with updating and inserting with no problems.
I'm trying to use qdf.Parameters() now, but I still get the popup. Is there a way to pass parameter without the parameter prompts?