Hi - I have a hopefully simple prob

[kirnavi]

Hi - I have a hopefully simple problem. I have a database with a lot of information, which includes almost 100,000 people. This database gets updated nightly.

Now, I need to create a separate database for our customer service dept when one of these people calls in. I would like a form where, once the Social Security Number is plugged in, all of the person's information automatically populates most of the fields.

I've linked the info table to the new database but am frustratingly unable to get the fields to populate.

I know there must be an easy solution I am missing. Can anyone help? I've am looking into DLookup but am a total newbie at VB.

Thanks,
Ellen

 

[jexster]

Im wondering if you could set up a search feature.

 

[rajeessh]

Using RecordSet and Populatinmg the values will be good

If u go for bound forms
Form the QueryDef as follows

If Table is not lineked
SELECT <TableName>.*
FROM <TableName> IN 'd:\xPathDir\xMDBName.mdb';

d:\xPathDir\ can be any Physical dir

If linked

SELECT <TableName>.*
FROM <TableName>


Let me know if worked sir