Refresh form while updating linked form
Utilizing Aceess 2000 and developing project tracking system. I have several tables linked together with one-to many relationships. Primary data entry is with "Projects" form/table that starts with the following fields: "lngProjectID"; "txtEmployeeID"; and then "lngCustomerID; etc.. The "lngCustomerID" field has lookup button to list all customers previously listed in "Customer" form/table. I also, added a "Add button" to "Projects" form to add new customers to the "Customer" form/table. After adding the necessary info in the first two fields on "Projects" form and adding a new customer to "Customer" form/table the lookup function does not see the new customer. Refresh does not work with the previous two fields completed. I need to have Access udate the database after the new "Customer" form is completed or when the Projects form "Customer lookup button is clicked on, maybe both! What is the best way to make this happen? Removing the first two fields on the "Projects" form and Refreshing is cumbersome. I am new to writting macros and VBA, please help!