Query + cumbo box

[Anton]

Hii guys ,
Am wondering if it is possible to put a cumbo within a query.
what i have in mind is to make a query which when opened the user can choose
his crieteria from a cumbo box which will then return the data required .

is it possible ???

 

[Rick Brandt]

Hii guys ,
Am wondering if it is possible to put a cumbo within a query. what i
have in mind is to make a query which when opened the user can choose
his crieteria from a cumbo box which will then return the data required
.

is it possible ???

No. You need to put the Combo on a form, then the user opens the form
first, chooses their criteria, then presses a button to run the query.
The query gets its criteria by referencing the form.

 

[Anton]

Ok i di dthe form with the cumbo box and have a query , how do i get the
query to use the form ..

 

[Anton]

wow sorry i am reading my reply again and now i notice how bad it sounds ,,,
but am try all sorts of things tosolve this issue and once i see some help
it is really getting me excited ...so pardon me for my english and hope to
find someone that can bear with me ....

 

[RonaldoOneNil]

For example, if your form is called Params and the Combo Box on it is called
cmbDept, then in your query you can enter [Forms]![Params]![cmbDept] in the
criteria row of the relevant column.

 

[Anton]

Nopes did not work ... i think its the form i must be doing wrong ,,,are ther
some specific properties i have to set on this form ??
Anton

For example, if your form is called Params and the Combo Box on it is called
cmbDept, then in your query you can enter [Forms]![Params]![cmbDept] in the
criteria row of the relevant column.

wow sorry i am reading my reply again and now i notice how bad it sounds ,,,
but am try all sorts of things tosolve this issue and once i see some help
it is really getting me excited ...so pardon me for my english and hope to
find someone that can bear with me ....