If I create a database that has 3 fileds per record; String1, String2 & ResultString. I want the user to enter in the first 2 strings then the program creates ‘ResultString’ by adding the String2 to String 1 itself.
Ie if you enter Big as String1 and Cat as String2 I want ResultString to be BigCat.
I guess I create a sub that is triggered by a change in either 1 of the 2 user entered fields then execute some code as below:
Data1.Recordset.Fileds(“ResultString”) = Data1.Recordset.Fileds(“String1”) + Data1.Recordset.Fileds(“String2”)
But I get a Null error. What am I doing wrong?
Many thanks for any help.