the easiest way is probably to create a udf function.
In a new module (not a form module) create the following - you can just copy and paste this code
Code:
Option Compare Database
Option Explicit
public function splitStr(str as string, element as integer) as string
dim strArr() as string
strArr=split(str," ")
splitstr=strArr(element)
end function
then in your form recordsource call it as
FirstName:splitStr(data,1)
LastName=splitStr(data,2)
etc
this relies on there being the same number of elements in each string and you don't have for example some entries where the person has a middle name, or a zipcode has not been included