Arrays

Hi

I attended a VBA course last week.

I have a form with around 10 input boxes (going into one table) for which i've added a command button to put the data to an array and to then put it to one of two tables depending on the results.

The problem I have is when i've input the data, the commend button code only works when I click onto the next record at the bottom of the screen first (thus saving the data to the table).

How do I get the command button to save the data to the bound table before going into the code etc?

Thanks

Robert