You use an unbound text box to display the results of a calculation, or to accept input from a user (as in the code example above).
To set the value of Textbox2 based on the value entered in Textbox1, you need to place your VBA code on the "After Update" event of Textbox1.
When the Choose Builder window appears, highlight Code Builder.
This object represents a text box control on a form or report.
Text boxes are used to either display data from a record source, or to display the results of a calculation, or to accept input from a user. You use a bound text box to display data from a particular field.
So the question is, how do i make it update "live" without having to click on the textbox with the mouse/curser?
Echo True Next That actually did work, but then the text is "highlighted", you know, as if i wanted to rightclick-copy or something...
However, if you then move to another record or save the record, the form's After Update event does occur.
To run a macro or event procedure when this event occurs, set the After Update property to the name of the macro or to [Event Procedure].
I want users only to be able to select an item from the combo which must populate the one textbox and then they can fill in the rest of the fields normally.
I am new at using VB to create a frontend for a DB as I normally use VB for excel manipulation so I am struggling to figure this out. EOF This works perfect as i said but I need to update the "com name" field which was created by VB6 data form wizard.
The changes that you make in the text box will be reflected in the underlying table.