Tricky thing in Querying!!!! (1 Viewer)

Ramshan

Registered User.
Local time
Today, 16:40
Joined
Aug 17, 2011
Messages
48
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.
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 10:40
Joined
Jan 20, 2009
Messages
12,849
Use a query on the Country table as the RowSource of the combo.
Set the BoundColumn as the number field.
If necessary adjust the ColumnWidths to show the name instead of the number
 

Ramshan

Registered User.
Local time
Today, 16:40
Joined
Aug 17, 2011
Messages
48
Can you please elaborate? I didnt get what are trying to say??
 

Users who are viewing this thread

Top Bottom