FindRecord is Replacing my Second Column

[JulieS]

I have a combo box that lists the ID in Column(0) and the Title in Column(1). When I use the docmd.FindRecord, it is replacing my Title with the previous ID (before the update). This is very curious because I've used the same code in other databases and its worked fine.

The code is as follows (where Title is the combo box and TitleID is the record I want it to find):

Dim VarID as Integer
varID = Forms![frm FAM Tour Main]![Title].Column(0)
DoCmd.GoToControl "TitleID"
DoCmd.FindRecord varID, A_START, , , , , True

 

[JulieS]

Fixed. I had changed the Title text box to a combo box. When I built it from a new combo box, it worked.
Whaddya know.