last record

[joe55]

hi all


i have a tbl called data this i run from a form called imput_frm



the problem i have is when i enter a new record i need to send this entry via e-mail (and nothing else)

i figured out the send by e-mail bit by atatching a macro "send oject"

the problem i have, how do i select the last record i entered when i tried this

if i entered more than one new record in a day i got both records when i only needed only the last record because i used the now() a select creteria i just wondndered is there a bit of code that help me on this ?


many thanks in advance Joe

[maximus]

if you have a bound form you can try

DoCmd.GoToRecord , , acLast

This will take you to the last record.