Enter Parameter Value Message when selecting from a combo box
why does it do this and how do I work around it?
Dim stDocName As String
Dim SelectedYear As Integer
SelectedYear = cboYear.Value
stDocName = "Overall Report"
DoCmd.OpenReport stDocName, acPreview, , "Year = cboYear.Value
Thank you for taking the time to report an issue.
What's wrong... Please write below.
When I added this subform to my main form and run the report I get a message"Enter Parameter Value Forms!BlendReport!ComboBlend" and then "Enter Parameter Value Forms!BlendReport!TxtDate". However, if I go to the forms list and then select the subform only and then enter a value in the combo box and text box the report (and query) run correctly.
I'm presenting the user(s) a form, with a combo box that contains 2 columns, I can bind either one, but the value I want stored is numeric. -1 for "Not Known", -2 for "NotApplicable" and x for "Enter Value", where "Enter Value" is a known number > 0.
What happens is the user really doesn't care to see the -2 or -1, but they do want to know what it stands for, or they want to see the actual value they've entered into that field (when selecting "Enter Value").
I've found that the combo box does not like it when you want to display the text value of the field OR the positive numeric value of the field, but the combo box is the user-requested medium to present the field.
I tossed around the idea of a text box to store the value as well, and making it visible/enabled when selecting "Enter Value" but it doesn't seem to be viable.
I want to filter a combo box from another combobox in the form. I have this this up in my DataEntryForm and it works fine.
It does not work in the Navigation form.
I get the error message:
ENTER PARAMETER VALUE
PROBLEM: When I open the main form [Quote Details], it opens just fine with all the subform fields blank. I go to the subform, click on the [cmbSupplier] and select the supplier. When I press enter, a message box pops up Enter Parameter Value: Forms!Quote Details!Quote Query!cmbSupplier.
If I enter the SupplierID in this box again, the cmbProduct populates correctly. I do not understand why it asks me for the parameter value when I just entered it.
When they select an address I want the building number associated with it to populate the first field.
However, I also have a central Navigation Form, frmNavigation, with tabs to different forms, including frmOCP. When I click on the frmOCP tab in frmNavigation, I get an Enter Parameter Value pop-up box, asking for the following information: Forms!frmOCP!cboFilterContract. As it happens, when I type in the name of the category that I want into this pop-up, the parameter works and I get what I want (the continuous form populates properly). I don't want it to prompt with a pop-up box, since the user uses cboFilterContract to do this. How do I suppress the pop-up box
However, when I select the value in the Bone combo box, I get a pop up saying "Enter Parameter Value." I cannot figure out how to get the Bone combo box to filter for the FracDesc1 combo box.