On Mon, 24 May 2010 08:19:01 -0700, Wordwonderor
wrote:

I'll be glad to try to help, but you'll need to help me do so: plsese post
your form's Recordsource, the combo box's Rowsource, and the datatype of the
solicoitor ID. I can't see them from here, and only that information will
enable me to reply.

I used the combo box but not sure how it works. I'd still like to know why
the DLookup which seems more direct didn't.

The forms record source is simply the Contacts table. The Solicior ID is a
number field in the Contacts Table and a autonumber in the Solicitors table.

"John W. Vinson" wrote:

On Fri, 14 May 2010 08:42:01 -0700, Wordwonderor
wrote:

Thank you, but it didn't help. The Solicitor ID control is on the form and it
updates as I scroll though the Contacts. But the Solicitor's name field (the
dlookup) doesn't. It always shows the solicitor with Solicitor ID 1.

Please post the SQL view of the form's Recordsource, and that of the combo
box's Rowsource. Also indicate the datatype of the SolicitorID.

I'd be inclined just to have a combo box bound to SolicitorID but displaying
the solicitor name, rather than having any DLookUp or separate control; is
there some reason you have chosen not to do so?
--

John W. Vinson [MVP]
.

--

John W. Vinson [MVP]