Auto populate

[paulmcdonnell]

Hi guys,


Easy one...

What's the quickest way to autopopulate a form with data in fields from the previously entered information...


Cheers
Paul

 

[vangogh228]

Paul:

I think we need a little more info to help you.

Tom

 

[paulmcdonnell]

Ok,

I have a form which is used to enter prospect information. In some cases 80% of the prospect information is the same for each prospect ie company address etc - but not always.

I have a toggle called "clone" (for want of a better word). which when its clicked (-1) , all the next new records are filled automatically with the previous records information.

I need it to be the last record enetered as the information.

Hope this is a bit clearer.

Cheers

Paul

 

[Fizzio]

Look up prevrecval in help or try here for a solution

http://www.access-programmers.co.uk/forums/showthread.php?threadid=21340&highlight=autofillnewrecord