open the dropdown box on sub form in VBA

[BBBryan]

Hi,
Wonder if someone can help.
I want to open the dropdown box on my datasheet view subform from the main datasheet view form when I run over it with the mouse.

From my main form textbox [WelderID]
I tried this code but doesn't work. I get the error invalid reference to the property Form/Report.

Private Sub WelderID_MouseMove(Button As Integer, Shift As Integer, x As Single, Y As Single)

Forms![Main]![WorkOrder Form]![DrawingNo fm]![Welds fm]![WelderStamp Sfm]![WelderStamp].SetFocus
Forms![Main]![WorkOrder Form]![DrawingNo fm]![Welds fm]![WelderStamp Sfm]![WelderStamp].Dropdown
End Sub


I am not sure if there is more code to use to open the subform in the datasheet view.


Thanks BBryan

 

[BBBryan]

Thanks for your comments.
If that is the case, I know I do not have the knowledge to do this.

Thanks BBryan