RecordSet for form determined by combo box selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like a combo box (cboMake) on my form (CustIntro) (currently based on
1 query) to change the record source of CustIntro. I would like cboMake to
choose one of four queries that I have already constructed. A (unbound) combo
box already exists on CustIntro to select records. The event code for After
Update is as follows:
Private Sub Combo26_AfterUpdate()
Me.RecordsetClone.FindFirst "[ID] =" & Me![Combo26]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
Thanks in advance for any help.
 
If you're trying to change the record source for your form, the Bookmark
command won't do it. The bookmark will try to move to a specific record in
the current recorset of the form. You need to determine the query or table
that you want to use for the form, then programatically set the form's
recordsource to that table or query, then requery the form.
 
Back
Top