Here it is,
In my query form i have a field called County, its a combo box and it contain the several values like Adair, alfalfa etc. so the user will be selecting one of this value to perform query operations. But here comes the problem, in the table where these values are stored they are stored in the number format, for example Adair = 109, Alfalfa = 126 etc.
So if I select Adair while performing query operation, it will go and check for the value "Adair" in County field and its throwing an error since the value is stored in number format. So i am struck with this. can you please help me on this. Thanks in advance.
P.S: I can't even attach my Database with this post, since I am new user. Maybe after few more posts I will have that privilege I guess.
In my query form i have a field called County, its a combo box and it contain the several values like Adair, alfalfa etc. so the user will be selecting one of this value to perform query operations. But here comes the problem, in the table where these values are stored they are stored in the number format, for example Adair = 109, Alfalfa = 126 etc.
So if I select Adair while performing query operation, it will go and check for the value "Adair" in County field and its throwing an error since the value is stored in number format. So i am struck with this. can you please help me on this. Thanks in advance.
P.S: I can't even attach my Database with this post, since I am new user. Maybe after few more posts I will have that privilege I guess.