Need your help

[dinadvani via AccessMonster.com]

Hello,

I need your help.

I have build a form which contains ID# which is unique. I need to pop up the
other details based on the ID#. But the problem is when I build a combo box
all the details gets aut populated but I only need 2-3 fields to get auto
populated.

For instance Results should be as below-

ID# First Name Last Name Acct type
1 Dfg hjg Service

Some thing like this, as the data which I have used for combo box contains
many other fields. I need this to add on further records, if all the data
auto populates it gets over-written and is quite confusing. So only the data
such as first name last name account type which is static and based on id #
is needed.

Thanks,
D

 

[dinadvani via AccessMonster.com]

Need your assistance Please....

Hello,

I need your help.

I have build a form which contains ID# which is unique. I need to pop up the
other details based on the ID#. But the problem is when I build a combo box
all the details gets aut populated but I only need 2-3 fields to get auto
populated.

For instance Results should be as below-

ID# First Name Last Name Acct type
1 Dfg hjg Service

Some thing like this, as the data which I have used for combo box contains
many other fields. I need this to add on further records, if all the data
auto populates it gets over-written and is quite confusing. So only the data
such as first name last name account type which is static and based on id #
is needed.

Thanks,
D

 

[BruceM]

You need to describe the purpose of the database, of the form in which the
combo box appears, and of the combo box itself. It sounds as if you are
selecting a record in the Vendor table (or whatever it is) when what you
need is a record in a related table, but this is a guess.