I have a form with a list box. The form is frmFamily and the list box is ChildList. The first column in ChildList is ChildID. I would like to double-click the list box and open frmChild, and take the ChildID from ChildList and enter it into ChildID on frmChild.
So far this is the code I've tried
Code:
DoCmd.OpenForm"frmChild",,,"[ChildID] = " & Me.ChildList.Column(0).Value
DoCmd.OpenForm"frmChild",,,"[ChildID] = '" & Me.ChildList.Column(0).Value & "'"
DoCmd.OpenForm FormName:="frmChild", WhereCondition:="[ChildID] = '" & Me.ChildList.Column(0).Value & "'"
All come back with an error "Object required." What am I missing?