I want clicker to appear in anther field after I click 'Add new record'

http://www.access-programmers.co.uk/ubb/smile.gif

I'm assuming that you want to move the focus do a different field after you click the add new button.

In the OnClick event of the cmdAddNew

fldName.setfocus

It does not work. Here is the code I typed
PO Number.setfocus in the On Click event

It does work if you use the right naming conventions. If a field name contains a space, you must be sure to enclose the name in brackets.

[PO Number].SetFocus

I did just like you said and it still don't work. I wrote over the word [Event Procedure] I am sorry, I hope I am not testing your patience.

I'm sorry. I was assuming that you were familiar with coding procedures.

When you look at the property window for the AddNew command button (you did create a command button to add a new record?) and click on the line for the click event, click the ellipsis (...) to the right of the entry line, and select code builder. Enter the code between the lines so it looks something like this

private sub command_onClick

[PO Number].SetFocus

end sub

It worked - thank you