Adding table new entries causing problems with form retrieving the data.

[wackywoo105]

I have quite an extensive form linked to a table. When I add new columns to the table I seem to have a problem getting the form to read the data.

I have just added a numerical column to the table and added a text box on the form that is bound to it. When I try to pull up the value using VBA it is blank, even though an entry is visible on the form. I have set the text box to general number and the entry shows in the actual table. When typing in the entry into VBA it capitalises where required so it must be registering the table entry. However the value it pulls remains blank.

I had a similar problem a while back and can’t remember how I got it to work.

Does anyone have a idea what the problem may be?

 

[spikepl]

Did you verify naming? For your textbox, in the Property Sheet, doublecheck ControlSource and Name

 

[wackywoo105]

That fixed it. What a stupid mistake to make. I think I am having one of those days.