Simple query

[DaveMere]

Hi all,

I'm designing a form containing a combo box which fetches it's data from a table, via a simple query. The table contains two columns - call them ID and FullName. The combo box presents the ID information for the user to choose from. I would like to set up a label elsewhere on the form that automatically fetches the FullName information from this table, corresponding to the current list box selection, and displays it for presentation purposes. I'd like this to update whenever the listbox selection changes.

Hope I've made this clear!

 

[IfButOnly]

Set up an unbound text box with the source as:-

---------------------------------
=[listboxname].Column(1)
---------------------------------

Column 0 is your ID, 1 is the name.

You can change the properties of the text box to prevent tab stops, edits, make it look like a label etc.

 

[cogent1]

You didn't make it clear whether your combo has both columns (ID & FullName), but it must have for Peter's solution to work.

 

[DaveMere]

Solution works perfectly.

Thanks.