Could you tell me how to make my forms open up ready to enter a new record?

Set the forms 'DataEntry' property to True.

You can hard code this in the forms properties or set it in code:

Me.DataEntry = True

Also you can remove this by setting it to false.

Thank you Travis. It asked that question on the MOUS expert exam and as I prepare to take it again, the information will be valuable. It is just a common sense idea that should probably be taught early in form creation.