combo box in query

[LouD]

How can i include a combo box in the criteria field in a parameter query

[Wayne Morgan]

The syntax to refer to the control on a form is:

Forms!frmFormNa me!ctlContolNam e

on a subform:
Forms!frmParent FormName!ctlSub formControlName .Form!ctlContro lName

The ctlSubformContr olName is the name of the control on the main form that holds the
subform, not the name of the subform itself.

--
Wayne Morgan
Microsoft Access MVP
"LouD" <du******@yahoo .com> wrote in message
news:3Z******** *************@n ews-server.bigpond. net.au...

How can i include a combo box in the criteria field in a parameter query

[LouD]

where do I put this syntax, at the mom what i have in the criteria field
is [enter name here]

Wayne Morgan wrote:

The syntax to refer to the control on a form is:

Forms!frmFormNa me!ctlContolNam e

on a subform:
Forms!frmParent FormName!ctlSub formControlName .Form!ctlContro lName

The ctlSubformContr olName is the name of the control on the main form that holds the
subform, not the name of the subform itself.

[Wayne Morgan]

Place it in the criteria field instead of what you have. Access will probably put brackets
around each part when you are done. The form must be open (visible or hidden is ok) for
this to work.

Remember the value of a combo box is the value of the Bound Column for the row that is
selected. If the value you are looking for is in a different column, you will need to
specify the column.

--
Wayne Morgan
Microsoft Access MVP
"LouD" <du******@yahoo .com> wrote in message
news:sg******** ***********@new s-server.bigpond. net.au...

where do I put this syntax, at the mom what i have in the criteria field
is [enter name here]

Wayne Morgan wrote:

The syntax to refer to the control on a form is:

Forms!frmFormNa me!ctlContolNam e

on a subform:
Forms!frmParent FormName!ctlSub formControlName .Form!ctlContro lName

The ctlSubformContr olName is the name of the control on the main form that holds the
subform, not the name of the subform itself.

[LouD]

Wayne

I tried suggesting what you said but it stll comes up as a msg text box
not a msg combo box heres is the sql the was genrated when i used to
wizard to set up the query
SELECT tblDetail.Det_I D, tblCategory.Cat _Code, tblName.Plant_N ame,
tblName.Generic _Name, tblContainer.Co nt_Size, tblDetail.Cost,
tblDetail.Price , tblDetail.Quant ity, tblLocation.Loc _Code
FROM tblName INNER JOIN (tblLocation INNER JOIN (tblContainer INNER JOIN
(tblCategory INNER JOIN tblDetail ON tblCategory.Cat _ID =
tblDetail.Cat_I D) ON tblContainer.Co nt_ID = tblDetail.Cont_ ID) ON
tblLocation.Loc _ID = tblDetail.Loc_I D) ON tblName.Plant_I D =
tblDetail.Plant _ID
GROUP BY tblDetail.Det_I D, tblCategory.Cat _Code, tblName.Plant_N ame,
tblName.Generic _Name, tblContainer.Co nt_Size, tblDetail.Cost,
tblDetail.Price , tblDetail.Quant ity, tblLocation.Loc _Code
HAVING (((tblName.Plan t_Name) Like "*" & [Enter the plant name or frist
characters of the name:] & "*"));

Yr assitance appreciated

Wayne Morgan wrote:

Place it in the criteria field instead of what you have. Access will probably put brackets
around each part when you are done. The form must be open (visible or hidden is ok) for
this to work.

Remember the value of a combo box is the value of the Bound Column for the row that is
selected. If the value you are looking for is in a different column, you will need to
specify the column.

[Wayne Morgan]

You're right, doing it this way won't bring up a combo box. To bring up a combo box you
will need to create your own form with a combo box on it then have the query's criteria
refer to that combo box.

What are you using this query for? If it is for another form or a report, you could pop-up
the form with the combo box in the OnOpen event of this other form or report using the
acDialog window mode argument. This will pause the code until you hide or close (you'll
have to hide it for the query to see it because it has to be open) the pop-up form and
will allow the value in the combo box to be set before the query is looking for it.

HAVING (((tblName.Plan t_Name) Like "*" & [Forms]![frmFormName]![ctlContolName] & "*"));
--
Wayne Morgan
Microsoft Access MVP
"LouD" <du******@yahoo .com> wrote in message
news:83******** *************@n ews-server.bigpond. net.au... Wayne

I tried suggesting what you said but it stll comes up as a msg text box
not a msg combo box heres is the sql the was genrated when i used to
wizard to set up the query
SELECT tblDetail.Det_I D, tblCategory.Cat _Code, tblName.Plant_N ame,
tblName.Generic _Name, tblContainer.Co nt_Size, tblDetail.Cost,
tblDetail.Price , tblDetail.Quant ity, tblLocation.Loc _Code
FROM tblName INNER JOIN (tblLocation INNER JOIN (tblContainer INNER JOIN
(tblCategory INNER JOIN tblDetail ON tblCategory.Cat _ID =
tblDetail.Cat_I D) ON tblContainer.Co nt_ID = tblDetail.Cont_ ID) ON
tblLocation.Loc _ID = tblDetail.Loc_I D) ON tblName.Plant_I D =
tblDetail.Plant _ID
GROUP BY tblDetail.Det_I D, tblCategory.Cat _Code, tblName.Plant_N ame,
tblName.Generic _Name, tblContainer.Co nt_Size, tblDetail.Cost,
tblDetail.Price , tblDetail.Quant ity, tblLocation.Loc _Code
HAVING (((tblName.Plan t_Name) Like "*" & [Enter the plant name or frist
characters of the name:] & "*"));