F
Funkydan
Dear All,
Im Back again,
I Need some help on creating some sort of query which displays results
of company's that are assigned a service type.
With in my Companies Contract Table i Have a Service Combo Dropdown
List(Field), which has a List of different services, ie Ductwork,
Pipework, Insulation, Boilers, Pumps, etc. The Different Services are
stored in a Seperate Table Called Services.
What Im Trying to do is, with on a seperate form, is have the same
dropdown menu with a search button. next to it, which when a user
Selects one of the services then press's Search, a new form opens up
and displays results of companys that are assigned to that Service.
Ive all Ready created a Query, and at the moment i have [Type Service]
in the criteria field in the design view in under service Field. But
this Creates a Parameter Search Box, and dont want this,
can some one assist me Please!!
Regards |
Danny
Im Back again,
I Need some help on creating some sort of query which displays results
of company's that are assigned a service type.
With in my Companies Contract Table i Have a Service Combo Dropdown
List(Field), which has a List of different services, ie Ductwork,
Pipework, Insulation, Boilers, Pumps, etc. The Different Services are
stored in a Seperate Table Called Services.
What Im Trying to do is, with on a seperate form, is have the same
dropdown menu with a search button. next to it, which when a user
Selects one of the services then press's Search, a new form opens up
and displays results of companys that are assigned to that Service.
Ive all Ready created a Query, and at the moment i have [Type Service]
in the criteria field in the design view in under service Field. But
this Creates a Parameter Search Box, and dont want this,
can some one assist me Please!!
Regards |
Danny