I am struggling to understand why a form, based on a query linking 2 tables (Main Form with zip code and 2nd form zip code with city name and county). When I display the form (while entering the zip code in the main form, the 2nd form city and county will be pulled in. I can reopen the main form and the city and county will be there... However, when I search for a particular record, then, the city and county won't show but #name? on both. Why is that and how to fix that? Thanks in advance.