Query-->Listbox--->Form Labels

[Infiltrate82]

Hello. I will try to explain this as detailed as I can because I can really use some direction! I have a form. On the form I have a text box. The value of the text box is ran in a search type query and the query results(often multiple) are displayed in a listbox. This is were im stuck. I want to be able to click on one of the results in the listbox and have all the columns in that row, be displayed in different labels. I dont know how to call/select the data thats being clicked first off. I don't have alot of experience with Access programming. Im a Marine, deployed to Iraq that was tasked with this job and trying to learn as I go. Im sure with a little guidance I can get this working. I just dont know where to go from here. Hoping someone can point me in the right direction.

 

[Dreamweaver]

In The Control Source of a text box add
=[Your List Name].Column(0) 'This returns the first column of the list
Then you can add more Text Boxes
=[Your List Name].Column(1) 'This returns the Second column of the list
=[Your List Name].Column(2) 'This returns the Third column of the list

Hope It Helps.
Might do a tutorial for this sort of referencing tomorrow.

Mick

 

[Infiltrate82]

Thank you so much for your speedy responds. I knew it had to be something small. It didnt seem to be that complicated of a task to do, I really just didn't know how to ask for what I wanted when I was searching. Thank alot.
Semper Fidelis.