davieboy_xr

hi.. got a bit of a bit problem editing records from text boxes.

On my form i have about 10 editable fields. When a click is detected in a textbox ,a separte form loads with a text box which displays the previous information , so that the user can edit the record.

my question is..
How can i detect which text box is selected so that i can update the relevant record in the database?
Thanks dave

LaVolpe

One easy solution: Try setting a form-wide variable as an object, i.e., Private LastText As TextBox
Then for each of your text box's GotFocus event, set LastText = thatTextbox.

davieboy_xr

thanks for the reply...bit lost now.. would i put this in the first form, not the editing form

MKoslof

If you have three text boxes on your form, in each one, you would assign this Got_focus event. So then, this private variable (within the scope of the form) would update accordingly. Interesting idea LaVolpe .

davieboy_xr

Thanks fellas ... ive declared it a public variable so now i can get the value in another form

So now what ill do is open up a connection to the database in the save button and then update the relevant record.
so then i have

Does that seems like the right way to do it?

LaVolpe

The answer is directly related to your first question.
The Private LastTextBox As TextBox statement goes near the top of the form that this code goes into.