Listbox unbound records

[bahalzamon]

Hello,

I have an unbound listbox and some unbound text boxes.
I am attempting to create code that will fill in the text boxes depending on which record I select within the list box.
The listbox does not have multi select on, only single select is possible.


I found listBox.Value which gives me the primary key which is nice, its something.

I have attempted several ways of things I have found online with no luck on how to get the remaining information into the other text boxes.
I have seen a for loop to find the one that is selected then using the listboxControl.Column(intColumn,intRow) but I obviously don't understand how to implement it.
The other option is to use a query but I am apparently doing that incorrect as well.
The query:

"SELECT [Student].[firstName] WHERE [Student].[SSID] = studentList.Value;"

I think this is the correct query but I cant seem to implement it either.

If you need/want any of how the code looks now please let me know. I know you don't want people saying "tell me how to do it." So if you have any resources I am good reading up further on it, I just cant find a place that I can get the required info. =)

Any help would be greatly appreciated.
-Bahalzamon

[ranman256]

you cant set a text box to many records from a multi select list. text boxes only hold 1 value.

if you need multiple values selected, dont use a multiselect list (takes lots of programming) instead, use a single -click action
to run an append query to put that item in a 'picked list' table.
This table can be joined with your main data to pull ONLY these items. 1 command, no programming.

[June7]

Are the textboxes bound to fields? If so, why?

Expression in textbox ControlSource can reference columns by index. Index begins with 0. So column 2 would be index 1.

=[studentList].[Column](1)

[bahalzamon]

@ranman256,

I do NOT need multiple values selected, just 1, and I wanted the text box to populate with the singularly selected item within the list box.
I am unfamiliar on what it is you are referring too, sorry, I am very new to Access, I am just unfamiliar with the syntax of Access.
Either way June7 came through again and answered it below. =)

-Bahalzamon

[bahalzamon]

@June7,

Wow do I ever feel dumb.
No the text boxes are not bound and I was attempting to keep them from that, having them unbound allows for more freedom.
I just needed them to fill in from the list box, I was not aware that that would work, I would have thought it would pull the entire column.
But now looking at it I should have known due to the listBox.Value returns the key, so basically telling it to use the key and go over X number of spaces. =)

Thanks again man, marking as Solved!
-Bahalzamon