(Q) I would be like to be able to have my form automatically go to a particular record
when I click a row in a list box or select a particular value in a combo box. How do I do
(A) If you have the ID column as the bound column in your listbox/combobox, you can put
the following code in the AfterUpate event of the control:
CAUTION: Make sure you have read
about the Bookmark Bug.
Me.RecordsetClone.Findfirst "[ID] = " & Me![ComboOrListboxName]
Me.Bookmark = Me.RecordSetClone.Bookmark