Combo Box Update

[Ean James]

I have a form that displays a list of users and there programs in a sub form, I would like a combo box instead of the user ID number so that I can press on it and all the user ID's will appear, then I can select it and there details will apear. Can this be done?

 

[Ean James]

?????????

????????????????

 

[Luddite Lad]

Sure it can.

 

[Ean James]

How is it done because all the ways I have tried just changes the number and I get errors?

 

[Ean James]

here is a small version of my db, I would be very gratefull of any help!

Thanks alots guys, I dont know what I'd do without this site!

 

[Ean James]

please??? anyone!!!

 

[John Big Booty]

Try this out. If it does what you're after you will need to do the polishing