Input Parameter Query Window - Duplicated?

[carrionk]

Hi,
I have created a Subform which SourceObject is a parameter query.

This is the Query:
Qry Name:80IsscomPr oduct

SELECT *
FROM Isscomp28
WHERE [BPP_NM] Like [Enter Product Name];

This is the code attached to a cmd button that updates a subform with
the result of the paramenter Query.

Private Sub CmdIsscombyName _Click()
'**** Update Subform
Me!sfrInfo.Sour ceObject = "Query.80Isscom Product"
'**** Update Label of Subform
Me!lblSfrInfo.C aption = "Complete Isscom List by Product"
End Sub

The problem:

The Enter Parameter Window seems to be duplicated. I fill out the
parameter and press Enter and the Enter Parameter Window appears again.

Any ideas why is this happening?
By now i can bypass the first Input Parameter pressing enter. I think I
can use sendkeys for solving this.....
Regards
LC

[Wayne Morgan]

On the form with the button, place a textbox to enter the parameter's value
in. Once the value has been entered, click the button. Change the parameter
in the query to point to this textbox and it will get the value from there
instead of prompting you.

Example:
WHERE [BPP_NM] Like [Forms]![MyForm]![MyTextbox];

--
Wayne Morgan
MS Access MVP
<ca******@yahoo .com> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. .

Hi,
I have created a Subform which SourceObject is a parameter query.

This is the Query:
Qry Name:80IsscomPr oduct

SELECT *
FROM Isscomp28
WHERE [BPP_NM] Like [Enter Product Name];

This is the code attached to a cmd button that updates a subform with
the result of the paramenter Query.

Private Sub CmdIsscombyName _Click()
'**** Update Subform
Me!sfrInfo.Sour ceObject = "Query.80Isscom Product"
'**** Update Label of Subform
Me!lblSfrInfo.C aption = "Complete Isscom List by Product"
End Sub

The problem:

The Enter Parameter Window seems to be duplicated. I fill out the
parameter and press Enter and the Enter Parameter Window appears again.

Any ideas why is this happening?
By now i can bypass the first Input Parameter pressing enter. I think I
can use sendkeys for solving this.....
Regards
LC