Microsoft Access 2003 forms

[Guest]

I am trying to make a form that when the user types in a field; it
automatically pulls up the rest of the information in two other fields.
For example: I have three fields;
a) identifier (formatted as number), b) lastname (text), and c) firstname
(text).
I want to be able to type in the identifier (number) and the form pull up
the lastname and firstname in the other two fields. Is this possible or do I
have to make one field for the lastname, firstname? I do not want to run a
query based on the table. I would like to make a form to where I can
retrieve information as soon as I type in another field. I am using
Microsoft Office XP (Access 2003). Please help!!!!

 

[Guest]

This is a classic question that gets repeated often.

In the source of the combo box you would need a query or table that has
multiple columns.

In the format properties

change the "column count" for the number of columns
In the "column width" put in the following 1cm;1cm;1cm (for as many columns)

When you click on the combo you should see all your information.

If your combo name is called "FIELD1"

In the after update event of the combo insert the following:

FIELD2 = [FIELD1].Column(n)
FIELD3 = [FIELD1].Column(n)

Where "n" is the column reference in the combo (first column = 0)

When you are sure you have the correct columns in the correct fields you can
change the width of the appropriate columns in the combo to 0cm.

 

[Guest]

Thank you.

This is a classic question that gets repeated often.

In the source of the combo box you would need a query or table that has
multiple columns.

In the format properties

change the "column count" for the number of columns
In the "column width" put in the following 1cm;1cm;1cm (for as many columns)

When you click on the combo you should see all your information.

If your combo name is called "FIELD1"

In the after update event of the combo insert the following:

FIELD2 = [FIELD1].Column(n)
FIELD3 = [FIELD1].Column(n)

Where "n" is the column reference in the combo (first column = 0)

When you are sure you have the correct columns in the correct fields you can
change the width of the appropriate columns in the combo to 0cm.

I am trying to make a form that when the user types in a field; it
automatically pulls up the rest of the information in two other fields.
For example: I have three fields;
a) identifier (formatted as number), b) lastname (text), and c) firstname
(text).
I want to be able to type in the identifier (number) and the form pull up
the lastname and firstname in the other two fields. Is this possible or do I
have to make one field for the lastname, firstname? I do not want to run a
query based on the table. I would like to make a form to where I can
retrieve information as soon as I type in another field. I am using
Microsoft Office XP (Access 2003). Please help!!!!