After I click button to add a new record, I want cursor to move to the first field. Does anyone have the answer to this?

In the On Current event of your form, put this code..

me![FirstFieldName].SetFocus

That should do it for you.

Doug

Thanks for message. When I enter this code, I get an error message saying Chemicals can't find a macro 'FacilityName' and won't view form - What am I doing wrong?