I've read the following post but what I would like to be able to do is to populate the form with a specific record (usually after completing a search form a search form). I've tried using the following code:
me.txtintcase = recs!intcase
but it only every seem to select the first record, any suggestions?
In the AfterUpdate event in the combobox control (I assume you are using a lookup list) use the following code;
Me.RecordsetClone.FindFirst "[CLAFieldName] = " & Me![controlName]
Me.Bookmark = Me.RecordsetClone.Bookmark
This usually works.