Data entry from TextBox

[Stemdriller]

Hi

I have a combo box that has 4 hidden values, I would like one of these hidden values to be added to a field in a table.

So I created a textbox with the control source pointing to the field and it's default value set to =[CompanyName].[Column](1) thinking it would place the value in the table. But alas not.

If I set the Control Source to =[CompanyName].[Column](1) of the text field I get the correct data, but cannot get the table to take the data????

Any Ideas??

 

[themurph2000]

Hi

I have a combo box that has 4 hidden values, I would like one of these hidden values to be added to a field in a table.

So I created a textbox with the control source pointing to the field and it's default value set to =[CompanyName].[Column](1) thinking it would place the value in the table. But alas not.

If I set the Control Source to =[CompanyName].[Column](1) of the text field I get the correct data, but cannot get the table to take the data????

Any Ideas??

If I read this right, what you want has to be done in code, and what you really want is the reverse of how you described it. When someone selects something out of the combo box, said value should be assigned to that text box and the text box's control source would be the field in the table.

It's hard to give you exact coding without seeing the original database, but your starting point would be the "on change" event of the combo box.

 

[Stemdriller]

If I read this right, what you want has to be done in code, and what you really want is the reverse of how you described it. When someone selects something out of the combo box, said value should be assigned to that text box and the text box's control source would be the field in the table.

It's hard to give you exact coding without seeing the original database, but your starting point would be the "on change" event of the combo box.

Patrick, you are an absolute star, a big big star, a big big big star.

I am forever in your debt. I never thought of that.

Many Many Thanks my good fellow

 

[missinglinq]

Actually, the AfterUpdate event of the Combobox would probably be a better choice for this kind of thing. In a Combobox, the On Change event will fire each time a user enters a character in the box, which may result in unwanted things happening and will assuredly result in unnecessary processing taking place. The AfterUpdate event only fires after a 'complete' selection has been made.

Linq ;0)>

 

[Stemdriller]

Actually, the AfterUpdate event of the Combobox would probably be a better choice for this kind of thing. In a Combobox, the On Change event will fire each time a user enters a character in the box, which may result in unwanted things happening and will assuredly result in unnecessary processing taking place. The AfterUpdate event only fires after a 'complete' selection has been made.

Linq ;0)>

Yes, I had already changed it to 'AfterUpdate'.


Many Thanks anyway for the tip

GW