I am responding to jon182 re how to change the record source for a form.
You may not be bringing up the correct property sheet for the form. To bring up the correct property sheet, click on the block at the left end of the ruler. There will be small black square in the middle of a larger gray square. If the ruler is not present, go to view and click to get the drop down list. There should be a check mark on the ruler entry. If not, click on the ruler entry. The ruler will appear on the form.
Bring up the property sheet again. Record source will be the first item in the property sheet. Click for the drop down list and select the new record souce. Please let me know if this works. Slim22 (Paul Robinson), pmr2212@aol.com