BarryBolin
Technical User
I am trying to filter data trhough uncontrolled selections in the form header. I have this successfully working on a form that only requires individual (single) filter sets.
I need to now get this to work on a form(table) that has 3 fields as its primary key. My linking constantly fails.
Code Used :
Else
Var_Sem_Code = Me!Search_Text_1
Var_Sem_Date = Me!Search_Text_2
Screen.MousePointer = 11
If Not (IsNull(Me!Search_Text_1) Or Me!Search_Text_1 = "") Then
DoCmd.ApplyFilter , "Sem_Code='" & Var_Sem_Code & "' and Seminar_Date=" & Var_Sem_Date '& "#"
::
I actually keep geting a pop-up that askes for the Value Of the text in the Sem_Code field (as a field name) very strange. The values in this field are "POS", "PRE" or "UNK" and the pop-up has the header of POS, PRE or UNK.
I an not sure why this is happening.
I need to now get this to work on a form(table) that has 3 fields as its primary key. My linking constantly fails.
Code Used :
Else
Var_Sem_Code = Me!Search_Text_1
Var_Sem_Date = Me!Search_Text_2
Screen.MousePointer = 11
If Not (IsNull(Me!Search_Text_1) Or Me!Search_Text_1 = "") Then
DoCmd.ApplyFilter , "Sem_Code='" & Var_Sem_Code & "' and Seminar_Date=" & Var_Sem_Date '& "#"
::
I actually keep geting a pop-up that askes for the Value Of the text in the Sem_Code field (as a field name) very strange. The values in this field are "POS", "PRE" or "UNK" and the pop-up has the header of POS, PRE or UNK.
I an not sure why this is happening.