Hi, Can someone help me format that this Dlookup so it works. I jus cant get the formatting right. Thanks.
txtScore.Value = DLookup("[Score]", "tblAQ", "ID = '" & Forms![frmQ]!cboP.Column(0) & "'" And "[Q No] = """ & Forms![frmQ]!txtQ & """")
txtScore.Value = DLookup("[Score]", "tblAQ", "ID = '" & Forms![frmQ]!cboP.Column(0) & "'" And "[Q No] = """ & Forms![frmQ]!txtQ & """")