How can I parse a field with separating commas

[Guest]

The field has information that must be parsed out -- it looks like this:
firstname,middlename,lastname,maidenname
I need to have each name in a unique field.

 

[Sergey Poberezovskiy]

Take a look at Split function - it may the answer you are
looking for:

Dim values as Variant
values = Split(inputString, ",")
firstName = values(0)
middleName = values(1)
...

HTH