I’ve built a table and form (access 97) to record customer details, all if fine except that when I open the form it goes to the 1st record, is there anyway I can amend this so that when opened it goes to a new record rather than the 1st?
that is set to run when the form opens.
The macro just has one parameter, and that is to go to "new record".
Also you can go to form properties and set dataentry to yes, but this will only show one new record while the rest are unaccessable. This maybe what you are actually looking for, if not, use the macro above.