 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / November 2007open a form based on another
I have two forms "client" and "employee details" I want to put a hyperlink on the client form that will open up the employee details. the relationship is as such. one to many client to employee details. client; ID, employee ID employee details; ID, client ID i think im getting stuck on the where condition.  Signaturebrandon A hyperlink is not approriate here. All you need is to use the OpenForm method. SignatureDave Hargis, Microsoft Access MVP > I have two forms "client" and "employee details" I want to put a hyperlink > on the client form that will open up the employee details. the relationship [quoted text clipped - 5 lines] > > i think im getting stuck on the where condition. OK but i still need to specify the where condition in the macro >A hyperlink is not approriate here. All you need is to use the OpenForm >method. [quoted text clipped - 3 lines] >> >> i think im getting stuck on the where condition. Signaturebrandon Don't use a macro. Just do it in VBA. SignatureDave Hargis, Microsoft Access MVP > OK but i still need to specify the where condition in the macro > [quoted text clipped - 5 lines] > >> > >> i think im getting stuck on the where condition. i dont know any vba >Don't use a macro. Just do it in VBA. >> OK but i still need to specify the where condition in the macro >> >[quoted text clipped - 5 lines] >> >> >> >> i think im getting stuck on the where condition. Signaturebrandon It would be something like EmployeeID = Forms!ClientForm!Employee Just use the name of the field in the other form's record source, and the name of the control in the current form that has the value you want to use. I suggest you learn VBA. It makes life a lot easier. SignatureDave Hargis, Microsoft Access MVP > i dont know any vba > [quoted text clipped - 4 lines] > >> >> > >> >> i think im getting stuck on the where condition. great thank you. any suggested books for reading... for a novice? >It would be something like >EmployeeID = Forms!ClientForm!Employee [quoted text clipped - 8 lines] >> >> >> >> >> >> i think im getting stuck on the where condition. Signaturebrandon Haven't read this one yet, but it may be an option for you: http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764556592.html SignatureDave Hargis, Microsoft Access MVP > great thank you. any suggested books for reading... for a novice? > [quoted text clipped - 10 lines] > >> >> >> > >> >> >> i think im getting stuck on the where condition. I have Access 2002. Would this book work for me? Jan >Haven't read this one yet, but it may be an option for you: >http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764556592.html SignaturePosted via a free Usenet account from http://www.teranews.com Yes, there is very little difference between 2002 and 2003. SignatureDave Hargis, Microsoft Access MVP > I have Access 2002. Would this book work for me? > > Jan > > >Haven't read this one yet, but it may be an option for you: > >http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764556592.html |
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.