 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007prefill
I enter ID and data on form 1. It gets stored in table A. I input same ID on form 2, for which I want a select number of fields (populated) from tableA to be displayed, then enter data into new fields on form 2 for which they will be stored in table B. I want the ID for both tables to be the same, so as the relationship is 1to1. (The PK are the same for each table).There is no changing what is on each form, and no making them subforms as this example is just a super watered down verison of what I have. I need help!!! (please no code use). How do I do this? - Noe If the relationship is one to one, why have two tables? What you are wanting to do would not be easy without some code.  SignatureDave Hargis, Microsoft Access MVP > I enter ID and data on form 1. It gets stored in table A. I input same ID on > form 2, for which I want a select number of fields (populated) from tableA to [quoted text clipped - 5 lines] > code use). How do I do this? > - Noe >I enter ID and data on form 1. It gets stored in table A. I input same ID on >form 2, for which I want a select number of fields (populated) from tableA to [quoted text clipped - 5 lines] >code use). How do I do this? >- Noe Well... there are two ways I can think of to do this. One involves subforms. The other involves VBA code. You've rejected both. So... sorry, your problem as stated probably has no solution. John W. Vinson [MVP] If I use macros, such as "requery" it accomplishes the task, but now how do I get the macro to stop going back to the 1st record after every update? >>I enter ID and data on form 1. It gets stored in table A. I input same ID on >>form 2, for which I want a select number of fields (populated) from tableA to [quoted text clipped - 12 lines] > > John W. Vinson [MVP] With the request for "no code" you can't! SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 If you could put the code down so all I'll have to do is copy and paste changing table names, is it possible? >With the request for "no code" you can't! |
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.