Macro Writing

[linanderson]

Hello,

I have a procedure which I undertake and wonder whether it can be automated in any way.

I have a field on a form for Purchases (frmPurchases) for a Purchase Order number. To get the order, I click on a command (cmdpo) which opens another form and clicking a command on this form (cmdgetpono) produces a unique Purchase Order number. I then manually copy the number given and paste it into the field on frmPurchases (PONo).

I have not used Macros before but cannot see that there are the options to achieve this. If someone could suggest the ones I should uses fro the list it would be appreciates.

Alternatively, is there another way of looking at this?

Thank you

Lin

 

[weilerdo]

RE Macro Writing

Lin, to populate the PO number back to the frmPurchase you could do this by setting the Control Source on you PO field in the form you want it to show up on. Something like this should work. In your frmPurchases PONo field on the control Source put =Forms!Name of Form!cmdgetpono which should work for you.

 

[linanderson]

Thanks for your reply.

I would however still have to open the form which creates the number (cmdpo) and then click on the command on this form (cmdgetpono). I was looking for a way of automating this whole process.

Any suggestions welcome