Copy info from one form to a 2nd

[Guest]

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

 

[Al Camp]

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.