By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,806 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,806 IT Pros & Developers. It's quick & easy.

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

stonward
100+
P: 145
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
Feb 8 '08 #1
Share this Question
Share on Google+
2 Replies


mshmyob
Expert 100+
P: 903
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

Expand|Select|Wrap|Line Numbers
  1. ' add a new blank record on your invoice form
  2. DoCmd.GoToRecord , , acNewRec
  3. ' grab a value from the 'search' form and store it in a control in your 'invoice' form
  4. Me!txtInvoiceControl.value=Forms!frmSearch.txtAnyControl.Value
  5.  
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
Feb 10 '08 #2

stonward
100+
P: 145
Thanx Mshmyob!

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

Thanks again

StonwardR
Feb 11 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.