 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2005Transfer Data From One Form To Another
I've been trying to do this for some time but just cant seem to get it right, please help. I have one form called"Job Details" which is like a work order. On this form i have a feild called"QuoteNumber". From the Job Detail form i have a command button which opens a new form called "Quotes" which when you start adding details you get a "QuoteNumber" created from AutoNumber. I want to transfer this "Quote Number" into my "Job Detail" form in the "QuoteNumber" field. Please help If each JobDetail row has only one Quote Number, why do you have a separate table for Quotes? > I've been trying to do this for some time but just cant seem to get it right, > please help. [quoted text clipped - 6 lines] > > Please help > If each JobDetail row has only one Quote Number, why do you have a separate > table for Quotes? [quoted text clipped - 13 lines] > > > > Please help i want to be able to a create quotes and not a jobdetail, therefore the autonumbers wont go jobdetail id1 and quote 1. You cant create more then 1 autonumber in any one table > > If each JobDetail row has only one Quote Number, why do you have a separate > > table for Quotes? [quoted text clipped - 13 lines] > > > > > > Please help I thought whenever you created a quote, you wanted its number to be transferred to y our JobDetail form... > i want to be able to a create quotes and not a jobdetail, therefore the > autonumbers wont go jobdetail id1 and quote 1. [quoted text clipped - 18 lines] > > > > > > > > Please help This might get you started: http://www.pacificdb.com.au/MVP/Code/MyDialog.htm Regards, Graham R Seach Microsoft Access MVP Sydney, Australia (Currently in Japan) --------------------------- > I've been trying to do this for some time but just cant seem to get it > right, [quoted text clipped - 10 lines] > > Please help |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.