 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2005Autolookup is not working
I followed all the steps to create a query for autolookup, but its not working. Would it be the fact that the unique field is an autonumber? I find the customer id on the main form and it populates in the subform. However, none of the other data populates, first name, last name. Help! I hope I understood what you trying to do. If you have a field in your form, unbound field, and you enter a customer number in and you want all the other fields in the form to refreshed then, first you need to filter the form recordsource with that field, and then on the after update event of that field you should write the code me.requery other wise the records wont refresh > I followed all the steps to create a query for autolookup, but its not > working. Would it be the fact that the unique field is an autonumber? I find > the customer id on the main form and it populates in the subform. However, > none of the other data populates, first name, last name. Help! what do you mean fileter the form recordsource with that field? thanks! > I hope I understood what you trying to do. > If you have a field in your form, unbound field, and you enter a customer [quoted text clipped - 7 lines] > > the customer id on the main form and it populates in the subform. However, > > none of the other data populates, first name, last name. Help! e.g form name MyForm Customer , text box name MyCust, table name CustList the recordsource for the form will be SELECT CustList.* FROM CustList WHERE CustomerID =[Forms]![MyForm ]![MyCust] so the recordsource refer to the field, now you just have to bound all the other field, and refresh the form after you enter a customer id > what do you mean fileter the form recordsource with that field? thanks! > [quoted text clipped - 9 lines] > > > the customer id on the main form and it populates in the subform. However, > > > none of the other data populates, first name, last name. 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
|
©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.