display form ready for data entry

[diversoln]

Ok for a great group like you this is gonna be a piece of cake...


I am calling up a data entry form from a menu and would simply like the form to open ready for data entry. The form defaults by displaying the first record - I want it to automatically go to the end of the table.


Thanks in advance !

 

[pbaldy]

You can set the "Data Entry" property of the form to Yes.

 

[diversoln]

Setting the "Data Entry" property to Yes certainly brought up the form in a data entry mode, but now I've lost the ability to access any of the previous records - its as if the only viewable record is the one being entered - in fact on the navigation bar it says record 1 of 1 when there are 500 records in the table. I'd like to retain the ability to view/edit the previous records.

 

[pbaldy]

Okay, set data entry back to no and put this in the load event of the form:

DoCmd.GoToRecord , , acNewRec

 

[diversoln]

That's the ticket. Works great !!!

Much Thanks.