[AccessD] Splitting Information from One field into Two

I can't find my sample code where I update two fields by splitting one.  I have a field NAME which contains: 
last name      comma     first name        Example:  Smith, John
I want to create two fields:  LastName     FirstName
I want to populate the two fields with the data from NAME.  Before the comma is the last name and after the comma is the first name.  I've seen the update code to do it but can not locate it now.  Please help.

* Amanda