datasheet subform, field manipulation

[scalle]

Here is my problem:

I got a subform that's in datasheet view.....
In this subform I got 2 columns that should be filled with values of 4
other columns.....

maybe you'll understand better like this:

column 1,2,3,4,5,6

so column 5 and 6 should be filled with the values of column 1 and 2 if
columns 3 or 4 are empty......

So I wrote something that does the job but not quite well.....;


I got in the datasheet lets say 4 records...... my vba checks only the
first record and fills all
other records with the values of the first one :s

can someone help me here.......

collumns 1,2,3 and 4 should be hidden and only 5 and 6 shown......


5 and 6 are shown but those fields are only needed as info, so they don't
have to be stored in a table or something.


thanks in advance