prefill

  • Thread starter Thread starter noe1818 via AccessMonster.com
  • Start date Start date
N

noe1818 via AccessMonster.com

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.
 
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
Click to expand...

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
Click to expand...
[quoted text clipped - 5 lines]
code use). How do I do this?
- Noe
Click to expand...

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]
Click to expand...
 
If you could put the code down so all I'll have to do is copy and paste
changing table names, is it possible?
 
Back
Top