How to create a query with multiple input values

[Guest]

I have a table field called CATEGORY. Using a query I would liike to choose:
Images, Print Forms or both. There will be no other options. This what I
have coded but I unable to achieve the result: [Enter Images, Print
Forms,CATEGORY:]


Everyday7

 

[John Vinson]

I have a table field called CATEGORY. Using a query I would liike to choose:
Images, Print Forms or both. There will be no other options. This what I
have coded but I unable to achieve the result: [Enter Images, Print
Forms,CATEGORY:]


Everyday7

The simplest way to do this would be to create a little unbound Form,
named frmCrit let's say; on it put a combo box, also unbound (nothing
in its Control Source) named cboCategory. Set its RowSourceType to
Value List and its Row Source to "Images;Print Forms;Both" (or
whatever three choices you want the user to see.

Use a criterion on CATEGORY of

=[Forms]![frmCrit]![cboCategory] OR [Forms]![frmCrit]![cboCategory] =
"Both"


John W. Vinson[MVP]

 

[Guest]

Thank you I will give it a try.
--
Everyday7

I have a table field called CATEGORY. Using a query I would liike to choose:
Images, Print Forms or both. There will be no other options. This what I
have coded but I unable to achieve the result: [Enter Images, Print
Forms,CATEGORY:]


Everyday7

The simplest way to do this would be to create a little unbound Form,
named frmCrit let's say; on it put a combo box, also unbound (nothing
in its Control Source) named cboCategory. Set its RowSourceType to
Value List and its Row Source to "Images;Print Forms;Both" (or
whatever three choices you want the user to see.

Use a criterion on CATEGORY of

=[Forms]![frmCrit]![cboCategory] OR [Forms]![frmCrit]![cboCategory] =
"Both"


John W. Vinson[MVP]

 

[Guest]

Here is the code that work:

Like "*" & [Please Enter Information] & "*"

Thanks for your help
---
Everyday7

I have a table field called CATEGORY. Using a query I would liike to choose:
Images, Print Forms or both. There will be no other options. This what I
have coded but I unable to achieve the result: [Enter Images, Print
Forms,CATEGORY:]


Everyday7

The simplest way to do this would be to create a little unbound Form,
named frmCrit let's say; on it put a combo box, also unbound (nothing
in its Control Source) named cboCategory. Set its RowSourceType to
Value List and its Row Source to "Images;Print Forms;Both" (or
whatever three choices you want the user to see.

Use a criterion on CATEGORY of

=[Forms]![frmCrit]![cboCategory] OR [Forms]![frmCrit]![cboCategory] =
"Both"


John W. Vinson[MVP]