Automatic Updating

[wop0703]

I have a form that has a combo box. The row source of the combo box is a query with 3 fields. I also have a text box located to the right of the combo box. I would like the first item to the left in my combo box to show up in the actual combo box when selected. Then I want the value of the second field to be automatically placed in the text box. I had this working kind of when my text box was a list box and in the combo box code i put

Me.MyListBox.Requery

But this changed all of my records from that point on. Everytime I change the value in the combo box, the list box value changed for every record.

Please Help.

 

[wop0703]

Yes, but I want to be able to add records too. And the towns would be different in every record. Could you modify the form to do that?

 

[wop0703]

Also, in the text Box you have =Combo0.Column(2)

When I do that to mine it puts [] around Combo0 and it does not work

 

[wop0703]

I mean go to add a whole new record. Like in your form. I would like to choose Reading and the number come up but then I want to go to 2 in the bottom left hand corner and choose Kintbury and have these values (Reading ### and Kintbury ####) stored in a table

 

[wop0703]

I did that, and it is still not working.

 

[wop0703]

OK, so I have a combo box that is fed from a table. The table has two fields which are both seen in the combo box. One value is a name. The other value is a number that is unique to that name. I want the name stored directly in the combo box (which happens) and I want the corresponding number stored in the text/list box next to the combo box. Now these two stored values are fed back into a separate table which records everything the user inputs. So the user can choose one name, then move to the next record and choose a diifferent name. Any help getting that number into the box next to the combo box?

 

[wop0703]

It still did not work, even with putting LocationShortName.Columns(1) . It still puts [] around LocationShortName . I am running Access 2000, is this maybe the problem.

 

[wop0703]

And I fixed it. User error. I was typing Columns instead of Column. I apologize for all of this. Thanks for your help.