Search results for query: *

That's what I had after fixing the provious mistakes I even paste yours my controlsource look like this: =DLookUp("[OtherCode]","DiagnosticMasterList","DiagnosisID = " & [Combo22]) still getting syntax errors I must be missing something

MajP you're right by the way sorry for the state of the database my predecessor was not a programmer that's why I have so many problems now. I get your point and although removing the quotes worked it did what you said it would. I added the line of code you provided to the Control Source of the...

I made the change but now I get #Error I am sure that the ID selected is ok I mean when I select a value from the combo i know it's the correct one. also I am sure the othercode field has the value I am looking for meaning the criteria is ok. my msgbox shows the DiagnosisID=1585 which exists in...

code is Private Sub Combo22_AfterUpdate() Dim SelectedID As String Dim Charcteristic As String Dim TableName As String Dim WhereClause As String Dim finalstr As String 'Charcteristic = "DiagnosisName" 'TableName = "DiagnosticMasterList" SelectedID = Me.Combo22.Value 'WhereClause = "DiagnosisID...

Hi, I have been trying to use dlookup for weeks but keep getting the #Name? error. I am attaching the database so you guys can help me fix this it's really urgent. Go to the form PatientCodedDiagnosis see the edit button press that and use the combobox to select something I call a qualifier...