Copy Info into to New Form

[RammerJammer1674]

Hello everyone. I have a [New Job Number] form in my database. In this [New Job Number] form, I have a [Purchase Orders] subform showing all open Purchase Orders. I have a button in the [New Job Number] form to open another form called [New Purchase Order]. How can I transfer all of that information from [New Job Number] into the [New Purchase Order] form through a macro? I don't know how to use VBA or modules so if you have any suggestions using those, please be very detailed. I do know how to use basic Macros, though.

The fields I would like to transfer from [New Job Number] into [New Purchase Order] are JobName, JobNumber, and CustomerAccountNumber.

Thank you!

 

[pbaldy]

Depending on version, I believe the macro action is either SetValue or SetProperty.

 

[RammerJammer1674]

Thanks for getting back with me so fast. I've tried the SetProperty Macro. It keeps giving me an error. I tried putting the macro in the "On Open" part of the form, but it won't do that either. I may just create a button to make it simple on myself. :banghead:LOL

 

[pbaldy]

The open event is too soon, I think; the load event might work. I would have put it behind the button you're opening the second form with.

 

[RammerJammer1674]

I tried it behind the OpenForm Macros I have to open the second form, but that is giving me an error as well. I'll try it OnLoad and let you know if that works!

 

[pbaldy]

If it doesn't, seeing the macro and the error would help to fix it.

 

[RammerJammer1674]

It worked OnLoad. I had to do a few SetTempVars but I manipulated it enough to make it work. Thanks a lot baldy!

 

[pbaldy]

Happy to help. I don't use macros, so I was making educated guesses.