code to move to next textbox when a command button is clicked

[Surek]

I have created a form using the wizard, to display the contents of the table.
I need to update the table by entering the data through the form.
When i click the update button of my form, it ignores the last text box value.
If i press tab and move to the next text box and click the update button, the last textbox value is taken into account.

When i click the update button, the cursor should automatically be moved to the next textbox. How can this be coded?
Can anyone suggest a solution for this?

[cyberdwarf]

Hi

Under normal circumstances you would use something like:

Me.NextTextBox.SetFocus

BUT what code do you have behind your "Update" button?

Steve

[Surek]

Hi

Under normal circumstances you would use something like:

Me.NextTextBox.SetFocus

BUT what code do you have behind your "Update" button?

Steve

Am getting the values from the textbox and performing some operations on tables.
since my form is created using a wizard it has only one textbox which dynamically retrieves data from the table and the textbox number increases according to the number of rows in my table.
So all the texboxes have a single name for ex. txt_total
So i need to know how can i refer to the next textbox

[cyberdwarf]

Are you talking about a scrolling list of records?

[NeoPa]

...
BUT what code do you have behind your "Update" button?
...

You will need to answer the questions if you want people to help you.