Rowsource on subform combo not working

[vmon]

I am using XP with SQL 2k . I have a combo box on a subform that I want the rowsource to be populated by the following statement. The procedure works if I enter an ID but does not work when called by form. The code is on the mainform. Any ideas?

Private Sub Form_Current()

Forms!frmScheduleProduction!frmScheduleProductionAssembly_sub!cboID_ITEM.RowSource = _
"EXEC lkpProductionAssemblyBomWu '" & Me.ID_SCHEDULE_PRODUCTION & "'"

End Sub

Thanks,
vmon

 

[WayneRyan]

vmon,

You're not referencing the subform's control properly.

Mile can help:

http://www.access-programmers.co.uk/forums/showthread.php?t=66115

Wayne