Retreiving data with multiple combo boxes

[ethorpe]

i have a query doing a lookup on a cost table retreiving the Rm name and the Cost based on the RM number. I also need the same query to retreive the RM number and Cost based on the RM name.


Can this be done in the same query or thur a Form?
If so please let me know how.

Thanks

 

[jimmythegeek]

Sure you can do this. First, could you post the SQL from the query, and second, could you explain exactly what you want to be able to do.

For example:
I have two combo boxes (box1, box2). I would like to be able to search by the first one OR the second one ..... etc.

If we have this info, we can get you the right solution. Jim Lunde
compugeeks@hotmail.com
Custom Application Development