Copy from Form to Subform

[Guest]

I am trying to copy data from a field in a form to a combobox (dropdown field) in a subform using a macro.

GoToControl Application
RunCommand Cop
GoToControl Forms![_Product_OLD_DATA Query]![Move Productxx].Form![Combo34]
RunCommand Past

The name in the properties section of the field I want to copy to is Combo34. I get an error message telling me there is No Field Named Combo 34 in the Current Record. It does not seem to be finding the subform. How do I bring up the subform so It can find combo 34
I have tried to use just Combo 34 and the name of the new field, Application alone with no luck.

 

[Steve Schapel]

Cronje,

I haven't tested this, but I'm pretty sure you will have to go to the
control on the subform in 2 steps, like this...
GoToControl [Application 1]
RunCommand Copy
GoToControl [Move Productxx]
GoToControl [Combo34]
RunCommand Paste

 

[Guest]

That was the answer. I can't believe I spent 8 hours trying to figure this out. Thanks for the help