prefill

[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

 

[Klatuu]

If the relationship is one to one, why have two tables?
What you are wanting to do would not be easy without some code.

 

[John W. Vinson]

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

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]

 

[noe1818 via AccessMonster.com]

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 - 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]

 

[Linq Adams via AccessMonster.com]

With the request for "no code" you can't!

 

[noe1818 via AccessMonster.com]

If you could put the code down so all I'll have to do is copy and paste
changing table names, is it possible?