Table will not update

[Pvarga]

I have a form to enter date. In one box I use a list box and store the first col. In another I have =[Combo129].Column(1) in the source box. It works great, selecting the proper info from the second field. But when I go to my table I see it does not store the info there. I can go back to my form and there is an entry in this field for every record but NONE of them are saved into my table. I am very new to Access and need things answered in simple terms.

Thanks much

Tricia

 

[Jack Cowley]

In the After Update event of Combo129 put code like this:

Me.NameOfFieldToGetValueFromCombo129 = Me.Combo129.Column(1)

Now that field should show up in the form and in the table with the data from Combo129.

 

[Pvarga]

I know I seem stupid to you but I cannot do this. I think I am getting the idea but seem to be messing it up. Are you saying I should go to my fist box (the one that is a list box)and in afterupdate event I am putting a statement that says the other field equals this one after update.

I tried to and get an error. This is what I typed
=[Me].[Text118]=[Me].[Enter].[Column](1)

My list box is "enter" and the one that should be pulling from col 2 of Enter is called "Text118". (I will give them proper names if I ever get it working)

Then if I get this I need to know what the Control Source for the 2nd box should be.

I appreciate your patience.

 

[Jack Cowley]

You do not seem stupid to me!

In the After Update event of your List box (Named Enter) put this code:

Me![Text118] = Me![Enter].Column(1)

This will put the item selected in the list box into the text box named Text118.

The Control Source for Text118 should be the field on the table where you want the selection from the List box to be saved to.

I do not understand your reference to the Control Source for the 2nd box. Sorry...

On word of caution - Be careful about changing field names, etc. once you get it working as you could really make yourself crazy as more things may be impacted by the changes than you realize. If it works then leave it for the moment and don't worry about the names.

If you cannot get this to work email me directly and I will send you a small demo.