 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2005Open new form to select data
Hi everyone, How can I set up a new form to open to select a customer from the customer table? I want sort of a pop up table that the user can double click on a record and get that customer name into the orders table. Currently I am using combo boxes but I'd prefer popup forms. I think it's really easy for many of you and I am having a mental block about it. Thanks Mike On the double click event of the customer list add the code Forms![FormName]![CustomerName] = me.customerlistname use it only if you open it from one form, but if you can open the customer list from few forms, then save the name in global variable and after you close the form assign that value to your main form. > Hi everyone, > [quoted text clipped - 6 lines] > Thanks > Mike Thanks for the help Ofer, but I get an error. The form that I want to put the info in is called Loads and the popup I want is called Customers. I set the double click event in Loads.customerID as follows Forms![Customers]![CustomerID] = Me.CustomerID Did I screw up? The customers form is a pre-existing one, do I need to change it? The error I get is Run time error 2450. Microsoft Access can't find the form 'Customers' referred to in a macro or VB code. Please help. Mike > On the double click event of the customer list add the code > Forms![FormName]![CustomerName] = me.customerlistname [quoted text clipped - 13 lines] > > Thanks > > Mike It should be as follow Put it in the event of on click of the customers list in your pop up form, that will return the value from the list in your pop up form called customer, to your field customer id in the main form called loads. Forms![Loads]![CustomerID] = Me.CustomerID (that meen that main form called loads, the field on the main form that suppose to get value called CustomerID , and the list on the pop up called CustomerID) I hope I understood corectly. > Thanks for the help Ofer, but I get an error. > [quoted text clipped - 34 lines] > > > Thanks > > > Mike Thanks a bunch I was trying to put the code on the loads form. I need only to open the customer form from there. > It should be as follow > Put it in the event of on click of the customers list in your pop up form, [quoted text clipped - 45 lines] > > > > Thanks > > > > Mike |
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
|
©2008 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.