If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy info from one form to a 2nd
I have two forms one call Solicitation and the other called Quotes. Each
form has its own table. Each day I enter into the solicitation form information including a solicitiation number and Quantity for each project that I will work on. When I am ready to quote this project I change a drop down box to "Quotes Pending" on the Solicitation form and then I open the Quotes form and fill in more information. My question is this: it possible to copy some of the infomation from the Solicitation form to the Quotes form? I would like to copy the solicitation number and the quantity from Solicitation form to the Quote form only when the drop down box says "Quotes Pending" on the Solicitation form. Any help is appreciated. Thanks. Mark |
#2
|
|||
|
|||
Copy info from one form to a 2nd
The easiest method would be to leave the Solicitation form open when you open the
Quotes form. You can directly interrogate the Solicitation form... on the frmQuotes FormOpen event. If Forms!frmSolicitation!YourComboName = "Quotes Pending" Then QuoteSolicitationNo = Forms!frmSolicitation!SolicitationNo QuoteQty = Forms!frmSolicitation!SolicitationQty End If OR... you could open frmQuotes from frmSolicitation, and use the OpenArgs argument in the form open method. ex. DoCmd.OpenForm "frmQuotes", , , , , , "FromSolicitation" Then... altering the original code in OnOpen... If OpenArgs = "FromSolicitation" Then QuoteSolicitationNo = Forms!frmSolicitation!SolicitationNo QuoteQty = Forms!frmSolicitation!SolicitationQty End If One minor note: Please don't start a duplicate question in another group without letting the first responder/s know that you plan to do so. GameGuru has responded on the Access group, so it would be polite to let him know you want to start another post. That prevents multiple solutions to one question on two separate groups where never the twain shall meet. -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "Mark Jackson" wrote in message ... I have two forms one call Solicitation and the other called Quotes. Each form has its own table. Each day I enter into the solicitation form information including a solicitiation number and Quantity for each project that I will work on. When I am ready to quote this project I change a drop down box to "Quotes Pending" on the Solicitation form and then I open the Quotes form and fill in more information. My question is this: it possible to copy some of the infomation from the Solicitation form to the Quotes form? I would like to copy the solicitation number and the quantity from Solicitation form to the Quote form only when the drop down box says "Quotes Pending" on the Solicitation form. Any help is appreciated. Thanks. Mark |
Thread Tools | |
Display Modes | |
|
|