I have a query that queries the combo boxes by using a form. The user selects all three and I need to fill in the text box automatically. The Dlookup does not store the field ODOBTX in the database field named as400 narr. Here is the query I use, How can I do this being new to access this is difficult.
WHERE (((OBJP1.ODLBNM)=[Forms]![Object]![cboODLBNM]) AND ((OBJP1.ODOBNM)=[Forms]![Object]![cboODOBNM]));