Unanswered: combo box fills subform data not main form
I have a combo box that is used to find the data from 2 tables, a Master and a Detail. After I enter the key value into the combo box, it retrieves the data from the Detail table and places it into the subform. Apparently it does not retrieve data from the Master table since that part of the main form is blank, except for the textbox that shows the master key value.
Here is the code that was generated from the wizard:
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ID] = " & Me![cboLookup]
Me.Bookmark = Me.RecordsetClone.Bookmark
I tried both the Me.ReQuery command and moving the combo box to the form header and to the form trailer with no success. A Find box created via the wizard gives the message "You can't use Find or Replace now".