Linking choice from listbox to fields

[PikPim]

Hi guys,
Here's the problem: I have a form in which users can select a product version and see the informations concerning this specific version of the product. To select different versions, I use a query that gives me all the version number for a specific product and all the other informations I need. Now, I would like to be able to dynamicaly update the other fields in the form so that, when a user select a different version, the informations corresponding to this version update correctly. The problem is that i don't know how to link the fields to the listbox. Plz help me!

Thanks in advance

 

[PHV]

You may consider playing with the Column property in the AfterUpdate event procedure of the ListBox.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PikPim]

ok thanks that was helpfull! Now, i've got another problem: I can't make the related fields update correctly. First I made a macro that executes after an update has been made on the listbox. The macro updates all the fields related one by one. Now my problem is that, if I leave the field as they were (i just drag and dropped them from the table) they won't update no matter what i do. I tried to input a value from a query as a control source (corresponding to the field I need but filtered by the query) but when I do that, the value in the field won't show and i got a #Name? instead...
help!! plz

 

[PikPim]

 

[creation303]

Very new at Access programming....how do I link two fields in a form? Both fields are in the same table...I have two fields supervisor ID and supervisor. After entering the supervisor ID, I want the supervisor name to enter automatically without the user typing it in the field.

 

[misscrf]

why not make the supervisor ID a combo. Turn ont the wizard so that when you plop a combo on the page, you will get the option to go to that record. Then the text box should update.

misscrf

It is never too late to become what you could have been ~ George Eliot