C
Chris Atlas
I have a form projects which has three tabs and is used for inputting
general information about a project. One of the tabs is used for listing
quotations made for this project and the quotations are listed in a sub
form. When creating a new quotation the user clicks on a New Quote control
button which opens up the Quotations form and allows iput for that
quotation. The following code runs on closing the quotes form
Private Sub Form_Close()
Form_ProjectMain.Requery
Form_ProjectMain.Visible = True
End Sub
This then lists the new quote in the quotation listing for that project.
This works fine for existing records or projects but if I create a new
project and while this is still open create a new quote then when closing
the quote form the list in the quotes tab of the main project does not
reflect the new quote unless I completely close the project form and reopen.
I know this is something to do with the project being a new record. Any
suggestions on how to fix this would be very welcome.
Thanks
Chris
general information about a project. One of the tabs is used for listing
quotations made for this project and the quotations are listed in a sub
form. When creating a new quotation the user clicks on a New Quote control
button which opens up the Quotations form and allows iput for that
quotation. The following code runs on closing the quotes form
Private Sub Form_Close()
Form_ProjectMain.Requery
Form_ProjectMain.Visible = True
End Sub
This then lists the new quote in the quotation listing for that project.
This works fine for existing records or projects but if I create a new
project and while this is still open create a new quote then when closing
the quote form the list in the quotes tab of the main project does not
reflect the new quote unless I completely close the project form and reopen.
I know this is something to do with the project being a new record. Any
suggestions on how to fix this would be very welcome.
Thanks
Chris