Duplicating Text in a Form

[Guest]

Hi All,

I found the listing here that shows how to write the code for a module to
duplicate info from one form to a new record on the same form (Funtion
AutoFillNewRecord). What I can't figure out is how to tell the command
button for add a new record to use this function. Can anyone help?

 

[Nick 'The database Guy']

Hi Alicia,

You must go in to the properties of a new command button, on the 'On
Click' event click the drop down and select 'Event Procedure', then
click the elipes (three full stops at the end) and select 'Code
Builder' you should have the VBA window up by now. The next think to
do is type in 'AutoFillNewRecord'.

It's done, just like magic!

Good luck

Nick

 

[Nick 'The database Guy']

Any feed back?

Hi Alicia,

You must go in to the properties of a new command button, on the 'On
Click' event click the drop down and select 'Event Procedure', then
click the elipes (three full stops at the end) and select 'Code
Builder' you should have the VBA window up by now. The next think to
do is type in 'AutoFillNewRecord'.

It's done, just like magic!

Good luck

Nick