Search results

SO i got it work yae!!! with the last post i made using [forms]![form1]![Combo4] I am creating a new post with next question about displaying the results in a sub form from my Locations Search Form

ALso i read that thi might work with my combo and forms names plugged in.. So, in the query builder, in the criteria section just type in [forms]![form1]![Combo4] But what criteria field do i enter it in when i have multiple fields and tables?

Official Name is the name of a column in my table. what should my query field name be im not sure what that is?? I spoke with a SQL DBA yesterday and she mentioned something about the combo box needs to pass the parameters threw. For example when i run the query now i get back all my location...

This what i came up with and the errors i got: WHERE OfficialName=Forms!Location_SRCH!Loc!Location_SRCH!LOC Is Null myfield= OfficialName, myformname=Location_SRCH, Mycomboname=loc Official name is the field that i want to be selected in the combo box. So for example a official name for one...

Thanks this is a project for work that i do in my spare time i will try this today and let you know how it goes. Please stand by for questions ;)

I have DB used for inventory for many different categories. I have a table and form for the following: Location, Printers, Pc's and many more. What i am trying to accomplish is to have a advanced search form that will display how many pc's and there makes and model from selecting the location...