If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
'Enter Parameter Value'
You can't close the form until you close the report. You can set the form's
visible property to No. And in the close event of the report, close the form. The query the report is based on uses the values of the controls on the form. When you close the form, the controls are no longer available. "Olu Solaru" wrote in message ... Does anybody have a permanent fix for the 'enter parameter value" dialog box that pops up after closing my query dialog form. I have gone back and looked at my query, the record source of my combo box. I even used some code that will set the recordsource value of the combo box to null, just before the DCmd.Close command. I just can't get this thing to stop. I also tried the suggestions on microsoft's website. Been working on this for a week, and it's starting to become a pain to solve. Scenario - Select a report from my reports menu, Custom Query Dialog form appears: {combo box, two command buttons( Open/Close) Problem happens when I click on the close button. Record source of combo box. - SELECT tblSopNumbers.ControlNumber FROM tblSopNumbers; SQL Code for query that report is based on - SELECT tblTraining.EmployeeID, tblSopNumbers.ControlNumber, tblTraining.Training_Validation, tblTraining.TrainingDate FROM tblTraining INNER JOIN tblSopNumbers ON tblTraining.ControlNumber = tblSopNumbers.ControlNumber WHERE (((tblSopNumbers.ControlNumber)=[Forms]![frmTraining Summary By SOP]![cboSop]) AND ((tblTraining.Training_Validation)='Yes')); |
#2
|
|||
|
|||
'Enter Parameter Value'
Where do I set the form's visible property to No - Is it in the Report's
close event ? "John Spencer" wrote: You can't close the form until you close the report. You can set the form's visible property to No. And in the close event of the report, close the form. The query the report is based on uses the values of the controls on the form. When you close the form, the controls are no longer available. "Olu Solaru" wrote in message ... Does anybody have a permanent fix for the 'enter parameter value" dialog box that pops up after closing my query dialog form. I have gone back and looked at my query, the record source of my combo box. I even used some code that will set the recordsource value of the combo box to null, just before the DCmd.Close command. I just can't get this thing to stop. I also tried the suggestions on microsoft's website. Been working on this for a week, and it's starting to become a pain to solve. Scenario - Select a report from my reports menu, Custom Query Dialog form appears: {combo box, two command buttons( Open/Close) Problem happens when I click on the close button. Record source of combo box. - SELECT tblSopNumbers.ControlNumber FROM tblSopNumbers; SQL Code for query that report is based on - SELECT tblTraining.EmployeeID, tblSopNumbers.ControlNumber, tblTraining.Training_Validation, tblTraining.TrainingDate FROM tblTraining INNER JOIN tblSopNumbers ON tblTraining.ControlNumber = tblSopNumbers.ControlNumber WHERE (((tblSopNumbers.ControlNumber)=[Forms]![frmTraining Summary By SOP]![cboSop]) AND ((tblTraining.Training_Validation)='Yes')); |
#3
|
|||
|
|||
'Enter Parameter Value'
No, in the report's close event is where you would close the form.
What event are you currently using to close the form? Instead of closing the form in that event, set the form's visible property to false. Do you have a button on the form to close the form? If so, change the code in the button so it doesn't close the form, but sets the form's visible property to false. Forms!YourFormName.Visible = False "Olu Solaru" wrote in message ... Where do I set the form's visible property to No - Is it in the Report's close event ? "John Spencer" wrote: You can't close the form until you close the report. You can set the form's visible property to No. And in the close event of the report, close the form. The query the report is based on uses the values of the controls on the form. When you close the form, the controls are no longer available. "Olu Solaru" wrote in message ... Does anybody have a permanent fix for the 'enter parameter value" dialog box that pops up after closing my query dialog form. I have gone back and looked at my query, the record source of my combo box. I even used some code that will set the recordsource value of the combo box to null, just before the DCmd.Close command. I just can't get this thing to stop. I also tried the suggestions on microsoft's website. Been working on this for a week, and it's starting to become a pain to solve. Scenario - Select a report from my reports menu, Custom Query Dialog form appears: {combo box, two command buttons( Open/Close) Problem happens when I click on the close button. Record source of combo box. - SELECT tblSopNumbers.ControlNumber FROM tblSopNumbers; SQL Code for query that report is based on - SELECT tblTraining.EmployeeID, tblSopNumbers.ControlNumber, tblTraining.Training_Validation, tblTraining.TrainingDate FROM tblTraining INNER JOIN tblSopNumbers ON tblTraining.ControlNumber = tblSopNumbers.ControlNumber WHERE (((tblSopNumbers.ControlNumber)=[Forms]![frmTraining Summary By SOP]![cboSop]) AND ((tblTraining.Training_Validation)='Yes')); |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Enter Parameter Value problem | [email protected] | Running & Setting Up Queries | 1 | July 24th, 2006 01:50 AM |
Enter Parameter Value Message | Lesley | Running & Setting Up Queries | 0 | July 14th, 2006 12:38 AM |
SQL false Enter Parameter prompt - need help | G Lykos | Running & Setting Up Queries | 1 | June 18th, 2006 02:16 AM |
Why am I asked to enter parameter value? (Second try) | JZ | Running & Setting Up Queries | 3 | May 18th, 2006 05:29 PM |
enter parameter value | Question | Running & Setting Up Queries | 3 | August 11th, 2005 09:58 PM |