Need help on designing form with old and new data

[Philippe]

I have to make a new form. In this new form, I want to
ask the user to enter an ID, then the form will populate
some fields, then the user fill the rest of the form with
new data.

I have two tables, A and B, A is the old table containing
data and B is the new one. There is a relationship
between A and B (ID).

The question is how do I make the form look for the data
into the table A when the user enter an ID? The form is
based on a query (maybe that is the problem?).

 

[Chris]

The easiest way is to do something like this:

Have a combo box for the ID's from Table A. In the combo
box RowSouce query, also include the other fields you want
to show. Name it something like cboID

Set the columnwidth property to 1;0;0;0;0;0; (as many 0's
as you need)

For each unbound control you will have, set it's
controlsource =

=cboID.column[1]


Chris

 

[Guest]

Thanks for the quick reply, but I've found another way.
I have scratched the query but maintain the relationsip.
Instead I have made a subform with the data needed from
table A, when user enters the ID, the subform populates
automatically.

Thanks again

hilippe

-----Original Message-----
The easiest way is to do something like this:

Have a combo box for the ID's from Table A. In the combo
box RowSouce query, also include the other fields you want
to show. Name it something like cboID

Set the columnwidth property to 1;0;0;0;0;0; (as many 0's
as you need)

For each unbound control you will have, set it's
controlsource =

=cboID.column[1]


Chris

-----Original Message-----
I have to make a new form. In this new form, I want to
ask the user to enter an ID, then the form will populate
some fields, then the user fill the rest of the form with
new data.

I have two tables, A and B, A is the old table containing
data and B is the new one. There is a relationship
between A and B (ID).

The question is how do I make the form look for the data
into the table A when the user enter an ID? The form is
based on a query (maybe that is the problem?).

.

.