Autofill a form in Access 2003 (1 Viewer)

[RobBhat]

Hi All

I have a form with a subform that requires inputting invoices from suppliers. For quite a lot of them, the majority of the information is a repeat of the previous invoice. Is there a command function that I can use to copy all the information from the previous record and insert them into the form and subform (excluding 3 of the fields in the mainform)?

Regards

Rob

 

[moke123]

there are probably several ways to do it but a lot depends on your workflow, the record sources of form and subform, etc. Also the need to copy info from record to record makes me wonder about normalization issues. Maybe supply more info or a sample of what you have.

 

[sneuberg]

Allen Browne has some code here that might get you started. To learn VBA I suggest starting with this video series.

 

[RobBhat]

Thanks Guys...Let me start with the code