copy a form field to another form? I guess

[mkelly]

I am working on an existing database created by another person for records management.

My question is.
It currently has a button on the enter records form that opens another form that will create an outo number for the box number. However on the enter records form this "box number" is input manually. It is causing alot of duplicate box numbers and with 60K records I cannot change the field to no duplicates.

Is there a way to on close or lost focus have the box number on the seconf form populate the box number text box on the first form?

 

[FoFa]

Yes, you can either do it in VBA (Forms!Main!Control = Me.Control) or you can use a macro with the setvalue verb

 

[mkelly]

Yes, you can either do it in VBA (Forms!Main!Control = Me.Control) or you can use a macro with the setvalue verb

Thanks for the info but I am still having a brain fart and can't get it to work.

How would I code the macro?

 

[FoFa]

SetValue Control you want to put value in and value you want to put

Since you wish to pull a value from a form, you can just use the builder to select the form and control to obtain the value from.