Filter information from a combo box to a combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Oscar R - 05 Feb 2008 21:30 GMT

I have a equipment table(EqID,Descr,location,etc)and a equipment fixed
table(JobID, empoyee, Location, EqDesc,etc) what i need to do is select in a
form from a combo box the location(already have) and select from another
combo box the equipment linked to the location filed, can some one help me
please

Reply to this Message

Douglas J. Steele - 05 Feb 2008 21:57 GMT

Take a look at any or all of the following:

http://support.microsoft.com/?id=209595
http://office.microsoft.com/en-ca/assistance/HA011730581033.aspx
http://www.mvps.org/access/forms/frm0028.htm
http://office.microsoft.com/en-ca/access/HA011730581033.aspx?pid=CH063650361033

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have a equipment table(EqID,Descr,location,etc)and a equipment fixed
> table(JobID, empoyee, Location, EqDesc,etc) what i need to do is select in
> a
> form from a combo box the location(already have) and select from another
> combo box the equipment linked to the location filed, can some one help me
> please

Reply to this Message

Klatuu - 05 Feb 2008 22:46 GMT

If I understand your question correctly, you need to use cascading combos.
So what you are saying is I want to select a location then select a piece of
equipment at that location, but in the Equipment combo, I only want to show
equipment at that location in the Equipment combo.

The technique is to create a query as the row source for the equipment combo
that is filtered on the location combo. Like:
SELECT EqID, Descr FROM tblEquipment WHERE location = Me.cboLocation

Then, in the After Update event of the Location combo, requery the Equipment
Combo:

Private Sub cboLocation_AfterUpdate()

Me.cboEquipment.Requery

Signature

Dave Hargis, Microsoft Access MVP

> I have a equipment table(EqID,Descr,location,etc)and a equipment fixed
> table(JobID, empoyee, Location, EqDesc,etc) what i need to do is select in a
> form from a combo box the location(already have) and select from another
> combo box the equipment linked to the location filed, can some one help me
> please

Reply to this Message