J
jason_canada
Guest
Hey everyone! I need to filter a database using two criteria values.
The values are: text box value from txtClientID and the string 'P'. The values in the database are the ClientID and the DomainType, either a P or an A. In this search it is for P. Can someone help me write a criteria string? This is what I have come up with, but it doesn't work!
strcriteria = ("[DomainType] = 'P' And [ClientID] = " & txtClientID)
rstDomain.FindFirst strcriteria
Any help will be appreciated.
Lieu
The values are: text box value from txtClientID and the string 'P'. The values in the database are the ClientID and the DomainType, either a P or an A. In this search it is for P. Can someone help me write a criteria string? This is what I have come up with, but it doesn't work!
strcriteria = ("[DomainType] = 'P' And [ClientID] = " & txtClientID)
rstDomain.FindFirst strcriteria
Any help will be appreciated.
Lieu