Filter combo box that looks up a record on my form??

[JOD59]

I need help with a combo box function that I have on a form. I used the combo wizard and created a combo box that looks up a record on my form, based on the value selected in my combo box. What I would like to do is filter the combo box . My database uses the project number as the unique identifier, but I would like the filter to limit displayed records by Project Name. There may be several project numbers associated with the same project name. This one has my limited ability stumped. Thanks for any help

 

[zevw]

What I understand from you!

That the Project Name - can have several project number as a customer can have several transactions.

In this case I would give every project a unique id as a autonmumber field and in you combo box select the project name, 1st column project id and 2nd column project name

create a subform which will look up all the project number link the master and child forms with project id and I think you will automatically get all the project numbers in your subform

Note: you will need the project id in both tables!!

 

[JOD59]

Thanks Zevw, ended up going another direction.