? about recordsetclone/combo/continuous form

  • Thread starter Thread starter EManning
  • Start date Start date
E

EManning

Using A2K adp. I have a form/subform and would like to use a combo box to
navigate the subform based on SSN. The form/subform are linked on
ConferenceID. So, a user would choose a name from the combo box (SSN is the
key and is the bound column) and the subform would automatically navigate to
the name requested. Is there a way to do this? I tried the following code
in the AfterUpdate event of the combo:

strCriteria = "[SSN] = " & conDoubleQuote & Me.cboSearch.Column(0) &
conDoubleQuote
Me.subfrmConferenceAttendance.Form.RecordsetClone.Find strCriteria
Me.subfrmConferenceAttendance.Form.Bookmark = _
Me.subfrmConferenceAttendance.Form.RecordsetClone.Bookmark

Nothing appears to happen.

Thanks for any help or advice.
 
Back
Top