I have a data entry form that cycles through fields and creates data in a table.



As I cycle through the form, I want the fields to pick up the value from the last record entered for entry into a new record.

I thought of using a macro to send the ctrl ' keypress on the got focus property for each field but the ctrl button isn't available in the macro.

I have tried some other things but nothing seems to work....

I'm sure this is something that is possible but I just don't know how to go about it and the help is not much help.

I'm using Access 2000-2002