Adding items to form in 'on-going' manner...

[stonward]

Hi Folks,

Still working on a beast of a system...I need a way to add a product that has been searched for on one form to another form. Inother words, I have (say) an invoice form open, and I need a method to add items to that form from a couple of possible search forms. Does this make sense? Can anyone help?

Thank you!

StonwardR

[mshmyob]

If you have run the search and found the record you are looking for you then just leave the 'search' form open and on your 'invoice' form you can reference any controls on the 'search' form like so from the 'invoice' form

' add a new blank record on your invoice form
DoCmd.GoToRecord , , acNewRec
' grab a value from the 'search' form and store it in a control in your 'invoice' form
Me!txtInvoiceControl.value=Forms!frmSearch.txtAnyControl.Value

Hi Folks,

Still working on a beast of a system...I need a way to add a product that has been searched for on one form to another form. Inother words, I have (say) an invoice form open, and I need a method to add items to that form from a couple of possible search forms. Does this make sense? Can anyone help?

Thank you!

StonwardR

[stonward]

Thanx Mshmyob!

Running late, but gonna try it today! Let you know how I get on...

Thanks again

StonwardR