I have a form with tabs and have information on one of the tabs from a subform. The subform gets its' data from a series of queries. Just for info, it's emergency numbers (ems, police or sheriff, etc) based on whether the client is in or out of the city limits and what city/county/zip combo they are. I have queries to pull numbers for locations out of city limits, numbers for locations in the city limits, match both separately to client ID's and then end up with a table with the combined data. I created a macro that runs a delete query to clear the table, then runs the two "final" queries to pull in the city and county info. I coded to run that macro "on current" for that tab. However, it shows "deleted" in all the fields.
I also did a union query and based the form on that query and it worked fine. However, it SEVERELY slows the database in that it is apparently updating everytime I move to another record.
If you need more info or specifics, please let me know. And thank you in advance for your help. I keep hoping that one day I'll be able to return the favor.
I also did a union query and based the form on that query and it worked fine. However, it SEVERELY slows the database in that it is apparently updating everytime I move to another record.
If you need more info or specifics, please let me know. And thank you in advance for your help. I keep hoping that one day I'll be able to return the favor.
