Enter Parameter Value message

  • Thread starter Thread starter Russ
  • Start date Start date
R

Russ

I've got a Access 2000 SP3 database form that performs just fine on
two of my computers, but when closed on another machine prompts me to
Enter Parameter Value for Forms![FormName]![SubFormName]![IDField]
If I Cancel or OK the prompt, it closes with no further problem.

All three machines are updated with the latest service patches and
fixes, and all three are running Win XP pro. There is no code on the
form except a Refresh macro in the after update event.

Is there some code that I can put in the close event that will trap
this?

Russ
 
Here's some information on this subject posted a while
back by MVP Sandra Daigle:
The way I have worked around the problem is to replace the
saved SQL for my combo boxes with SQL that is built 'on-
the-fly' in response to the After-Update event of the
related control and in the Current event of the form.
Another method of allievating the problem is to use the
Click event of your close button to first set the
rowsource of the offending combobox to the nullstring (""
or vbnullstring).

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.
--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
This could be a bug talked about in this KB article. I
believe it also applies to Access 2000. See:

http://support.microsoft.com/?id=811860

--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
I've got a Access 2000 SP3 database form that performs
just fine on two of my computers, but when closed on
another machine prompts me to Enter Parameter Value for
Forms![FormName]![SubFormName]![IDField]
If I Cancel or OK the prompt, it closes with no further
problem.

All three machines are updated with the latest service
patches and fixes, and all three are running Win XP pro.
There is no code on the form except a Refresh macro in
the after update event.

Is there some code that I can put in the close event that
will trap this?

Russ
Click to expand...
.
Click to expand...
 
Without trying any of these solutions, the simplest to me seems the
Echo false / echo true procedure. I would also like to try the
methods provided by Sandra Daigle, but it is a bit confusing to me.
How would I set the rowsource of the offending combobox to the
nullstring "" ?

The offending textbox is called "SubCatID"

Russ



Here's some information on this subject posted a while
back by MVP Sandra Daigle:
The way I have worked around the problem is to replace the
saved SQL for my combo boxes with SQL that is built 'on-
the-fly' in response to the After-Update event of the
related control and in the Current event of the form.
Another method of allievating the problem is to use the
Click event of your close button to first set the
rowsource of the offending combobox to the nullstring (""
or vbnullstring).

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.
Click to expand...
 
I assume you have your own close button on the form. I
believe either of these should work:

Me.SubCatID.RowSource = ""
Me.SubCatID.RowSource = vbNullString

Just put one of those before the code line that closes the
form. I am unable to reproduce this at home at the moment
because the bug only affects Windows XP I believe.
You could try the following code in the command button
that closes the form:

Private Sub cmdCloseForm_Click()
On Error GoTo ErrorPoint

Me.SubCatID.RowSource = ""
' Or this one
' Me.SubCatID.RowSource = vbNullString
DoCmd.Close acForm, Me.Name

ExitPoint:
Exit Sub

ErrorPoint:
MsgBox "The following error has occurred:" _
& vbNewLine & "Error Number: " & Err.Number _
& vbNewLine & "Error Description: " & _
Err.Description _
, vbExclamation, "Unexpected Error"
Resume ExitPoint

End Sub

--
Jeff Conrad
Access Junkie
Bend, Oregon
-----Original Message-----
Without trying any of these solutions, the simplest to me
seems the Echo false / echo true procedure. I would
also like to try the methods provided by Sandra Daigle,
but it is a bit confusing to me.
How would I set the rowsource of the offending combobox
to the nullstring "" ?

The offending textbox is called "SubCatID"

Russ



Here's some information on this subject posted a while
back by MVP Sandra Daigle:
The way I have worked around the problem is to replace the
saved SQL for my combo boxes with SQL that is built 'on-
the-fly' in response to the After-Update event of the
related control and in the Current event of the form.
Another method of allievating the problem is to use the
Click event of your close button to first set the
rowsource of the offending combobox to the nullstring (""
or vbnullstring).

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this
newsgroup.
Click to expand...

.
Click to expand...
 
Back
Top