I know the right value is being returned by the recordset to set the criteria. the answer to this look up should be "American Express".  I previosly tried it with Nz(DLookup("Category", "AccountCategories", "ACID = """ & RS.Fields(2) & """"), "Empty").  No matter I couldn't get the function to operate.

Thanks

Is your ACID numeric?

Why are you using Fields(2) instead of the field name?

I'd have to test this and I'm not at a computer right now, but I don't think you have access to the RecordsetClone collection when Form_Load runs. The recordset isn't fully loaded yet. What are you trying to do (in English)?

Thanks for your help.  In my Account Profile table i use the ID for the Account category. When the form opens, I simply want to display the the Name of that Category instead of the number.  That is all.  Damn, that's it.  I'll just create a query that includes the field in the control source.  The control source is the table itself!!!

I do have the correct value in the recordset.clone.  When the program is in debug mode, when I hover over that rs field it dispalys the correct number '3"

Of course, when I run query on that ID, it shows the correct name for that category

The ACiD is the primary index for that record.

You figured out the solution yourself. Just use a query to pull in the name. If you don't want to do that, you could use a DLookup in the control source of a text box, or even a locked combo box. You don't need anything to do with recordsets - or even VBA for that matter. You're trying to open a can of Coke with a jackhammer. :)