I may being trying to accomplish this the wrong way but, I have a list box which is filled by a sql query when opening a form. It is just one value, but when trying to save the record it will not save the list box record unless the box is selected. Is there a way to assign a value to a text box with a sql statement? Or is there a better way to accomplish this? Thanks for the help!

Can you use DLookup to get your value instead of the SQL?

Can you give me a example? I have never used DLOOKUP...here is my sql statement I used to obtain my value:

SELECT tblStandards.UNITOFMEASURE, tblStandards.STDID, tblStandards.CODE FROM tblStandards INNER JOIN tblFacCode ON tblStandards.CODE = tblFacCode.CODE WHERE (((tblStandards.STDID)=[STANDARD]))

Any ideas?

I do appreciate the help!

DLookup can only return one value....