i have attached a .mdb because i have a feeling i am not going to explain my problem very well.
When the form opens, i want a new record to be the focus and not the 1st record in the table.
Any ideas please?
I tried your solution by changing "FormName" to the name of my subform and main form (not at the same time) but neither worked.
Should the code go in the onopen event of the main form?