I have a main form to populate a table holding details on various projects I am working on. I also have separate tables/forms to hold costs and funding for each project. I had a problem earlier this week of being able to create these associated records which I have now resolved thanks to help in this forum. However, what I want to do know is to be able to view a summary of cost information on the main projects form. The main projects form is query driven but the only way I can update the summary cost information on it is to close and then reopen it ie re-run the query. The process I go through is:
1) Open projects form and add a new or find an existing record.
2) Click required command button on my projects form to allow me to goto the other forms eg costs. This doesn't close the Projects form.
3) Go onto the cost form and update information as necessary
4) Close the Cost form. The Projects form is behind this so is viewable straight away but the cost summary is understandably unchanged.
I don't want to use pop-ups or tabs.
Can anyone help???? Thanks
1) Open projects form and add a new or find an existing record.
2) Click required command button on my projects form to allow me to goto the other forms eg costs. This doesn't close the Projects form.
3) Go onto the cost form and update information as necessary
4) Close the Cost form. The Projects form is behind this so is viewable straight away but the cost summary is understandably unchanged.
I don't want to use pop-ups or tabs.
Can anyone help???? Thanks
