well I finally figured out why my query with the two tables (active and inactive) were not working. so now I need to figure out how create a form with an unbound list box that says Active and Inactive, so when yoiu choose inactive or acitive you see alll the data from those tables which is now in a query. The two tables are not exactly the same in their fields.
Last edited:
