Query criteria from combo box on form

[phil123]

Hi,



I have a few successful queries working in my database where the criteria under one of fields pulls from a combo box on a form.

I am now looking to see if one combo box can be used for multiple criteria's in a query. Basically I have a few tables where a staff members name will appear next to a task. I want to be able to select this staff members name from a combo box and this retrieves all tasks where this persons name has been assigned.

I think I may have read somewhere that a combo box cannot be used in this way - which seems so far to be the case. If I copy the code in the query into the different fields, the query doesn't run properly.

Any suggestions as to how I get this to work?

Thanks,

Phil

[June7]

Yes, can be done. Did you try using OR operator?

What do you mean by 'next to a task'? Post example of data.

[phil123]

Hi June7,

Thanks for your reply.

By task I just mean that my database is being used to make sure that a number of different jobs relating to a process (in which our company carries out) and completed on time. By putting a name next to each of these I can ensure that each 'job' is accountable for and a search can easily be carried out

At the minute I'm using the code [forms]![frmSearchbySeniorAdmin]![cboSeniorAdminName] within the query. On the search form there is then a command button which opens the display form and populates using the query.

However if I copy this code above in to different fields in the query, it doesn't seem to work. How exactly would and OR operator be applied in this case (apologies my Access knowledge is still quite basic).

Just to mention as well, these 'jobs' are recorded in different tables which are brought together via a series of subforms. All are linked together via the ID number. Don't know if this information is helpful or not.

Many thanks,

Phil

[June7]

Really just more confusing. Why would jobs be in different tables? Provide sample data. Or the db. Follow instructions at bottom of my post.

[davegri]

Need a lot of info here to get an understanding of what you have and what you are trying to accomplish.
We would need:
Table names and field names in all tables
Picture of relationships (this would actually cover above requirement)
Pictures of your forms and subforms
Recordsources for above forms and subforms
Rowsources of the combo boxes.
And perhaps more if above leads to more questions.

So, as June7 suggested, it would be easier to provide a zipped copy of your database which would include all of the above and more.