I have a form (frmProviders) that reads the record source "providers".
In that table there is a lookup to another table "states". when creating a new record in Providers I allow a lookup to the states table ,so the user doesnt have to type in the two digit state abbr each time.
On the form (frmproviders) i want tobe able to filter all the records to only display a certain state. When i use a combo box "and select find records on form" the value the box is displaying the two digit Code associated with the state and not the two character abbrreviation (ie. Al).
What am I dont wrong?