Listbox into textbox when you click on a name.

[DanJames]

I have a list box with peoples names in from a table, and I'd like it if when I click on a name that persons details came up in different text boxes on the form. So I'd have text boxes showing first name last name ect.. Thanks in Advance, Dan

 

[NigelShaw]

Hi

if i'm understanding you correctly,

Make sure the form is bound to the table or query
add your fields
use the wizard to create a listbix and select the option "use a field on the form" or something similar to this description

then, when you click on the listbox, the fields will change.


Regs

Nidge

 

[DanJames]

Thanks alot mate, you got me on the right track and now I have it sorted! Thanks again, Dan.