Re: 'Enter Parameter Value'

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <OluSolaru@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C0B3A046-D79F-4F2E-9042-08C12A5F9A2A@xxxxxxxxxxxxxxxx
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" <OluSolaru@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:861681E3-2835-4D67-918D-D289692D0119@xxxxxxxxxxxxxxxx
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'));






.

Relevant Pages

  • RE: Combo Box Problem
    ... "Your Record Source query doesn't appear to have an filter. ... record source query it won't display in the report? ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: Query form coding
    ... The record source for the list box "namelst" is: ... The report record source seems to give the desired records. ... The code for the button (create the filter) works if no names have been selected in the names list box. ... I have tried to include the query when using the wizard to design the report but I keep getting an error saying I have used a table or query that is based on a table or query and when I remove the query fields from the list it allow me to continue with the report design. ...
    (microsoft.public.access.formscoding)
  • Re: Create sums on different groupings?
    ... You could base your main report on the group by and totals query I suggested ... by Name, date, and Amount. ... Then add this query to your report's record source so you have the 375" ...
    (microsoft.public.access.reports)
  • Re: Create sums on different groupings?
    ... I used Query1 as the record source for the main report and Query2 as the ... "Duane Hookom" wrote: ... You could base your main report on the group by and totals query I ...
    (microsoft.public.access.reports)
  • Re: Create sums on different groupings?
    ... I used Query1 as the record source for the main report and Query2 as the ... "Duane Hookom" wrote: ... You could base your main report on the group by and totals query I suggested ...
    (microsoft.public.access.reports)