I am working on an Access 2013 db and I am trying to populate some text boxes bases on a dlookup statement.
I have the first part working fine but I can't seem to get it to work with multiple criteria.
=DLookUp("[GLNumber]","Qry_gl","[custname] = '" & [Forms]![Frm_Productiondata]![CustName] & "'")
This is working. Then next criteria should be the Query Qry_GL description field should = newsprint. I can't seem to get all the quotes in the correct order to make this work. Newsprint is text and not coming from the form.