repeated name showing on my pull down menu.

[JoyJoy329]

I'm currently having a giant one table access file. Due to the nature of my
compnay. I file all the information according to the Job number we originally
assign the product once we got the order. Here is the problem. when i created
a pull down list to select the designer name from the list and then the
detail information of the job pops up and I realize that if one designer did
more than one job for us.. his name will appear on my list according to the
number of the job he did for us.. is it possible to solve this??

 

[Jeanette Cunningham]

Hi JoyJoy329,

you could try using a DISTINCT query as the row source for the combo.
In query design, click in the query's design space where the tables are and
open the query's property sheet.

Set Unique Values to Yes, if that doesn't help, try with Unique Records set
to Yes.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[JoyJoy329]

Thanks So much.. it solved my problem...

Hi JoyJoy329,

you could try using a DISTINCT query as the row source for the combo.
In query design, click in the query's design space where the tables are and
open the query's property sheet.

Set Unique Values to Yes, if that doesn't help, try with Unique Records set
to Yes.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[JoyJoy329]

This solved my problem, but somehow the full detail below is now not set to
show just the name i selected.. can you kindly tell me how to solve this
again?? thx

 

[Jeanette Cunningham]

I have a question or 2 for you. After you choose a name from the drop down,
what records do you see in the form?
What code do you have on the after update event of the drop down?
How is your form set up?
If you choose just the designer in the drop down, then it will should be
possible to show all the jobs that match that designer.

Here is a link to a site with a sample database that uses a drop down to
show the matching records in the form.

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=379


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[JoyJoy329]

Jeanette,
I got the zip file already and i really like to use the dual combo on my
form. Do u think it's possible that u can take a look @ what i've done so far
and give me some advise on my database??

 

[Jeanette Cunningham]

I would love to help, but I have paying clients and deadlines and no spare
time.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia