G
Guest
Hi. This should be really easy but I must have a block or something. I have
created a Search Form with a number of unbound boxes some of which are combo
boxes. In these cases the Row Source is (ie. SELECT DISTINCT
Tbl_MAIN.Province FROM Qry_Search).
While my query and table actually displays the province, on the Search Form
when you click on the drop down, the options are 1,2,3.... which is of course
the Province ID from Tbl_Province.
How can I make the search fields show the appropriate text options? Thanks!
created a Search Form with a number of unbound boxes some of which are combo
boxes. In these cases the Row Source is (ie. SELECT DISTINCT
Tbl_MAIN.Province FROM Qry_Search).
While my query and table actually displays the province, on the Search Form
when you click on the drop down, the options are 1,2,3.... which is of course
the Province ID from Tbl_Province.
How can I make the search fields show the appropriate text options? Thanks!