Linking Fields

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

Hello All!

I have a table that contains 22 fields in this table I
have two fields, field A is the company name and field B
is the company ref code. This is what I would like to
happen:

When I am using the form I would like to select the
company name and then the corresponding company ref code
would be filled in in the next field automatically.

I have made a query for these two fields in my table but
don't know what is the next step.

I'm sure this is possible but just don't have a clue as to
how to get it to work.

Any and all help will be much appreciated.

Thanks in advance - Allie
 
Allie said:
Hello All!

I have a table that contains 22 fields in this table I
have two fields, field A is the company name and field B
is the company ref code. This is what I would like to
happen:

When I am using the form I would like to select the
company name and then the corresponding company ref code
would be filled in in the next field automatically.

I have made a query for these two fields in my table but
don't know what is the next step.

I'm sure this is possible but just don't have a clue as to
how to get it to work.

Any and all help will be much appreciated.

Thanks in advance - Allie
Click to expand...


One of the easiest ways of achieving what you want is to use the New
Form wizard to create your Form, using the Query you have created or
the Table itself.

To be able to find a record and have the Form's Textboxes filled in,
use the combobox wizard in the Toolbox to create a combobox, on your
Form, that finds a record based on what you type.

hth

Hugh
 
Back
Top